Home » Developer & Programmer » Forms » Master Details Relationship (Forms6i)
Master Details Relationship [message #290582] Sun, 30 December 2007 01:31 Go to next message
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
Re: Master Details Relationship [message #290625 is a reply to message #290582] Sun, 30 December 2007 22:28 Go to previous messageGo to next message
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
Re: Master Details Relationship [message #291923 is a reply to message #290625] Mon, 07 January 2008 04:34 Go to previous messageGo to next message
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
Re: Master Details Relationship [message #292111 is a reply to message #291923] Mon, 07 January 2008 21:20 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
which master block ? BILL_HEAD or BILL_TAIL ?

Quote:

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


Minto
Re: Master Details Relationship [message #292174 is a reply to message #292111] Tue, 08 January 2008 02:33 Go to previous messageGo to next message
mahaveer
Messages: 16
Registered: July 2000
Junior Member
i.e BILL_TAIL
Re: Master Details Relationship [message #292189 is a reply to message #292174] Tue, 08 January 2008 03:12 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
can u pls attach the fmb.

Minto
Re: Master Details Relationship [message #292229 is a reply to message #292189] Tue, 08 January 2008 04:18 Go to previous message
NasirPanwar
Messages: 8
Registered: August 2005
Location: Faisalabad
Junior Member

Why don't you merge BILL_TAIL and BILL_TAIL_DET tables as you have one to one relationship?
Previous Topic: commiting time
Next Topic: All V2-style triggers
Goto Forum:
  


Current Time: Tue Dec 06 02:14:44 CST 2016

Total time taken to generate the page: 0.11289 seconds