Home » Developer & Programmer » Forms » Master-Detail-Detail Relationship (Form 6i,oracle 10g,Window NT)
Master-Detail-Detail Relationship [message #378413] Tue, 30 December 2008 05:38 Go to next message
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 Go to previous messageGo to next message
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
Re: Master-Detail-Detail Relationship [message #378560 is a reply to message #378557] Tue, 30 December 2008 23:42 Go to previous messageGo to next message
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.



Re: Master-Detail-Detail Relationship [message #378613 is a reply to message #378560] Wed, 31 December 2008 02:02 Go to previous messageGo to next message
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



Re: Master-Detail-Detail Relationship [message #378615 is a reply to message #378613] Wed, 31 December 2008 02:05 Go to previous messageGo to next message
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
Re: Master-Detail-Detail Relationship [message #382656 is a reply to message #378613] Fri, 23 January 2009 08:09 Go to previous message
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
Previous Topic: Exporting the data to an excel sheet
Next Topic: Insert SQL--- LONG datatype..
Goto Forum:
  


Current Time: Sun Dec 04 02:32:30 CST 2016

Total time taken to generate the page: 0.11818 seconds