OraFAQ Forum: Forms » Master Details Relationship

Home » Developer & Programmer » Forms » Master Details Relationship (Forms6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master Details Relationship [message #290582]

Sun, 30 December 2007 01:31

mahaveer
Messages: 16
Registered: July 2000

Junior Member

I have tables as below

1.Bill_Head

Bill_No
Bill_Date
Fin_Year_Cd
Remarks

2.Bill_Tail

Bill_No
Product_Cd
Amount
Ded_Amount
Net_Amount

3.Bill_Tail_Det

Bill_No
Product_Cd
Quantity
Rate
Interest_Percent
Service_Charge
Vat_Tax_Percent

The Relation is like

Between BILL_HEAD and BILL_TAIL is Master Details Relation

Between BILL_TAIL and BILL_TAIL_DET is one to one relation

In single form i am not able to insert record.

If i build Master details between BILL_HEAD and BILL_TAIL, BILL_TAIL and BILL_TAIL_DET, when i run the for to insert data.

I will put the data for BILL_HEAD data

For this parent record there will be child record in BILL_TAIL block.

For this BILL_TAIL parent record there may be a child record in BILL_TAIL_DET or may not. Suppose i put a child in BILL_TAIL_DET.

Then i wanted put one more child record in BILL_TAIL block, if i say next record, it is asking me to "save the record first".

Please help me in this regards

my mail id : mahaveer@somaiya.com

Regards
Mahaveer

Attachment: RUNTIME_MESSAGE.JPG
(Size: 95.96KB, Downloaded 517 times)

Report message to a moderator

Re: Master Details Relationship [message #290625 is a reply to message #290582]

Sun, 30 December 2007 22:28

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

hi,

can you try doing the modification in the program unit Clear_All_Master_Details :

Comment the line Clear_Block and add a line of code to POST data.

-- Clear_Block(ASK_COMMIT);
POST;

Minto

Report message to a moderator

Re: Master Details Relationship [message #291923 is a reply to message #290625]

Mon, 07 January 2008 04:34

mahaveer
Messages: 16
Registered: July 2000

Junior Member

Thanks Minto,

I tried accordingly, now it is not asking me to Commit the record before navigating next record in master block (i.e. Bill_Tail).

But if i comes back to first record in Master block, it should fetch the data in detail block, which is not happening.

Please suggest.

Regards
Mahaveer

Report message to a moderator