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
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 Go to previous message
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.
Previous Topic: putting current time in the text box
Next Topic: DISABLE COMMIT ON database BLOCK
Goto Forum:
  


Current Time: Thu Feb 13 09:47:44 CST 2025