daogu

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

---

Answer: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.

Minto

---

Answer: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

---

Answer: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

---

Answer:i.e BILL_TAIL

---

Answer:can u pls attach the fmb.

Minto

---

Answer:Why don’t you merge BILL_TAIL and BILL_TAIL_DET tables as you have one to one relationship?

Related posts:

1. master detail relation iam having difficulty problem with master details relation strucure...
2. Master-Detail Relationship Problem Dear All, I’m a new member in orafaq goup...
3. Form Updation(linking of three tables) hai, i have threee tables 1)master 2)parent 3)child strucure...
4. Customized Master-Detail Form Hi all, I m preparing a Master-Detail form which...
5. unable to delete master which has detail Hi all, I have 3 blocks namely block1, block2,...