Home » Developer & Programmer » Forms » Problem setting Mater Detail relation (10g Application Server win xp)
Problem setting Mater Detail relation [message #339745] Fri, 08 August 2008 06:10 Go to next message
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member

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 Go to previous message
Messages: 21151
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.
Previous Topic: DISABLE COMMIT ON database BLOCK
Next Topic: Problem with 2 LOV's
Goto Forum:

Current Time: Thu Aug 24 02:03:36 CDT 2017

Total time taken to generate the page: 0.14341 seconds