| Master-Detail relationships in different canvases [message #88386] |
Mon, 29 July 2002 23:22  |
Alberto Urbano
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Hi.
I'm trying to use a master-detail relationship in a form which has two canvases. In the first one I've put the fields for the master table, and in the other one, the ones for the detail table. When a query is executed over the Master Block, it only returns data from this block, and doesn't query the detail block. If now I enter this block, the query is executed and I obtain the data of the detail corresponding to the master record.
If I remove the second canvas and put the detail fields in the first one, the query is executed correctly and I get the results of both tables.
Is there any way to solve this?
|
|
|
|
| Re: Master-Detail relationships in different canvases [message #88403 is a reply to message #88386] |
Thu, 15 August 2002 03:51  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
To solve this problem you have to write a PL/SQL block
for both mater and details.
on master block after enter query.
check system.Block_status
event and if it not changed or query. / the no of rows retrieved.
according to this fire query on detail canvas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
