Problem setting Mater Detail relation [message #339745] |
Fri, 08 August 2008 06:10 |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
Hi,
I created two blocks (in 2 different forms)and now want to set up a master detail relation between them but when I try to create a new relation from the master block it does not show the detail block (which is in another form) as the probable target.
Screen shot attached
RDC_REQUIREMENT is the form which contains the master data block (DB_REQUIREMENT) and RDC_SUBMISSIONS is the form which contains the detail block (DB_SUBMISSIONS). When I press the '+' to create a new relation in the master block (DB_REQUIREMENT) a list appears which asks me to select the detail block but the DB_SUBMISSIONS block is not there in the list.
Does this mean that to establish a master detail relationship the two blocks have to be in one single form? If I can do this then how?
|
|
|
Re: Problem setting Mater Detail relation [message #339752 is a reply to message #339745] |
Fri, 08 August 2008 06:33 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Master-detail is to be done in the same form, not between blocks in different forms.
If you want to refer to certain "master" values from another form, you'll have to use a parameter or a global variable which will then be used in the "detail" form.
|
|
|