Master-Detail Peril
From: Jappi Mulder <sanjayp_at_pacsoft.com.fj>
Date: 11 May 1998 02:03:34 GMT
Message-ID: <01bd7c80$f72b2560$0300000a_at_sanjay>
Hi! I am new to Oracle.
I have created a Master-Detail Related Form. On the same Canvas the Master Block is
Clients containing Contact_name(PK), Contacts_Company_name, and the Details BLK is Course_Enquiry containing Course_Name, Course_Contact_Name (FK).
Date: 11 May 1998 02:03:34 GMT
Message-ID: <01bd7c80$f72b2560$0300000a_at_sanjay>
Hi! I am new to Oracle.
I have created a Master-Detail Related Form. On the same Canvas the Master Block is
Clients containing Contact_name(PK), Contacts_Company_name, and the Details BLK is Course_Enquiry containing Course_Name, Course_Contact_Name (FK).
On New Form Instance Trigger, 2 LOV's fire. First Forms 4.5 selects distinct Company_Name, and then a 2nd LOV selects clients related only to that Company. After this a query executes, populating the Course_Enquiry BLK with details. This is fine, but when I try to add new records to the details BLK and save an error appears saying it is unable to update.
Please tell me why this occurs?
Sanjay
Sanjayp_at_pacsoft.com.fj Received on Mon May 11 1998 - 04:03:34 CEST