OraFAQ Forum: Forms » Master-Detail-Detail Relationship

Home » Developer & Programmer » Forms » Master-Detail-Detail Relationship (Form 6i,oracle 10g,Window NT)

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

Master-Detail-Detail Relationship [message #378413]

Tue, 30 December 2008 05:38

manudu20
Messages: 45
Registered: August 2008
Location: Mumbai

Member

Can we make Master-Detail-Detail relationship in form 6i,I tried but when i press back button in D2 block to return D1 block it asks to commit.
But i want to make a form in which i can enter multiple record againse one record in detail block.

If anyone have any example of this type of form please send it to me..

[Updated on: Tue, 30 December 2008 05:43]

Report message to a moderator

Re: Master-Detail-Detail Relationship [message #378557 is a reply to message #378413]

Tue, 30 December 2008 23:34

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

It is very simple to make master child relationship in Forms6i and here is an example.

Bhupinder Singh

Attachment: master_child_form.fmb
(Size: 88.00KB, Downloaded 1855 times)

Report message to a moderator

Re: Master-Detail-Detail Relationship [message #378560 is a reply to message #378557]

Tue, 30 December 2008 23:42

manudu20
Messages: 45
Registered: August 2008
Location: Mumbai

Member

Thanks but you have sent master-child relationship ex form in which we can insert multiple record in child block against one master record.
But i need to further enter multiple recor against one detail record.
Means i want to create master-child-child relationship form.

Report message to a moderator

Re: Master-Detail-Detail Relationship [message #378613 is a reply to message #378560]

Wed, 31 December 2008 02:02

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Ofcourse you can have following combination of releationships:
1) Master with one child
2) Master with many childs
3) Master with one child and again a child will be master for
another child. (Form attached here. check program unit
TABLE_LIST for table scripts)
4) Child with many masters (example in next reply)

Bhupinder Singh

Attachment: Master_child_and_Child_with_Child.fmb
(Size: 100.00KB, Downloaded 1671 times)

Report message to a moderator

Re: Master-Detail-Detail Relationship [message #378615 is a reply to message #378613]

Wed, 31 December 2008 02:05

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Child with many masters (example attached (Tables needs to be created. I don't have scripts with me right now for that. These can be created lookling at database block columns)).

Bhupinder Singh

Attachment: detail_with_many_masters.fmb
(Size: 116.00KB, Downloaded 1452 times)

Report message to a moderator

Re: Master-Detail-Detail Relationship [message #382656 is a reply to message #378613]

Fri, 23 January 2009 08:09

pooja_j
Messages: 2
Registered: April 2008

Junior Member

Hi,

I have a question regarding the form - Master_child_and_Child_with_Child.fmb.

The 'Delete Record Behaviour' of the relation TAB1_TAB2 is 'Non-Isolated'.

The 'Delete Record Behaviour' of the relation TAB2_TAB3 is 'Non-Isolated'.

If i change the 'Delete Record Behaviour' of the relation TAB1_TAB2 as 'Cascading' and delete a record in TAB1 , it automatically deletes the detail record in TAB2. This is because of the Cascading behaviour.

Now, my question is : How does the record in TAB2 get deleted when the relation between TAB2 and TAB3 is non-isolated?

Regards,
Pooja

Report message to a moderator

Previous Topic:	Exporting the data to an excel sheet
Next Topic:	Insert SQL--- LONG datatype..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 17:54:29 CST 2025