|
|
|
|
|
|
Re: Oracle forms [message #510232 is a reply to message #510224] |
Fri, 03 June 2011 01:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Example based on Scott's EMP table:
- using Data Block Wizard, create a master block. Its base table is EMP, the only column you'll choose is DEPTNO
- create its layout - form style (which means that you'll see only one item on a canvas)
- create another block (using Data Block Wizard again). It will be a detail block.
- Its base table is EMP again. This time select ALL items.
- Create master-detail relationship (manually, within the Wizard) by joining DEPTNO items from both blocks
- layout should be "tabular"; display as many records as you wish (10, for example)
- run the form. While in master block, perform query. It (master block) will contain 14 records (if the EMP table is the "original" one), and you'll scroll through 14 DEPTNO values (some of them will be duplicate, of course). Detail records will automatically change, as you scroll through master records
That should be all, I suppose.
|
|
|
|
|
Re: Oracle forms [message #624269 is a reply to message #624248] |
Fri, 19 September 2014 14:38 ![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 |
|
|
As it takes MINUTES to create a sample form based on Scott's tables, I hope you took that effort and checked whether it works or not. Because, it's been 6 hours between you posted a question & me seeing it.
|
|
|