| master detail block question [message #164748] |
Sat, 25 March 2006 05:41  |
haitham
Messages: 60
Registered: February 2006
|
Member |
|
|
hi... am a beginner in database developing
i made a master data block and detail data block using the join relationship in a form, and what i need is that when i type the primary key value in the master data block then the referenced foreign key values will be displayed in the text items of the detail data block..
i think this issue is related with the on_populate_details trigger...wot trigger or built ins to use to do that ? ,, plz help ...
thanks alot ..
[Updated on: Sun, 26 March 2006 03:06] Report message to a moderator |
|
|
|
|
|
| Re: master detail block question [message #164846 is a reply to message #164748] |
Mon, 27 March 2006 00:55  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Please search this forum for 'master detail'. There are numerous threads.
Short answer: create master block, create detail block, create the 'relations' between the master and detail block, populate primary key of the master block in its When-Create-Record trigger, define primary key field of 'detail block' as being a 'copy of' the primary key of the master block (this is an item level property), populate secondary key of the detail block in its When-Create-Record trigger.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
