|
|
|
|
|
|
|
Re: display two department employee details at the same time in Master/Details Relation [message #603614 is a reply to message #603610] |
Wed, 18 December 2013 00:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
The way you described it, this is NOT a true master-detail relationship. "Master" (DEPT) and "detail" (EMP) blocks are kind of related (because employees work in departments), but Forms master-detail works in a way that you select one master record which displays none, one or more detail records.
Therefore, don't create any kind of relationship (such as the one Forms Wizard creates).
As you want to select more than one department, I believe that you'll have to do the whole job manually: based on selected departments, create a WHERE clause for the "detail" block and set it using SET_BLOCK_PROPERTY & its ONETIME_WHERE or DEFAULT_WHERE. Then execute query in the detail block.
|
|
|