Home » Developer & Programmer » Forms » regarding master-detail relationship
regarding master-detail relationship [message #214263] Mon, 15 January 2007 10:31 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello All,
I have three blocks two master and one detail
depta --master (for displaying single record)
emp --detail (for displaying multiple records)
dept_mult --master (for displaying multiple records)
so there are relationship between depta,emp and dept_mult,emp.
emp block is on the stacked canvas so it is displaying on both canvas.
if i will execute query in last maintained block then it is displaying correct records in detail block,but previous maintained relation is giving incorrect no of records in detail block.so only one relation is working fine.what should I do to correct both relation?
i am enclosing module in forms 6i with these relationship.

Please reply...
  • Attachment: MODULE1.fmb
    (Size: 100.00KB, Downloaded 162 times)

[Updated on: Tue, 16 January 2007 09:47]

Report message to a moderator

Re: regarding master-detail relationship [message #214543 is a reply to message #214263] Tue, 16 January 2007 23:27 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try creating a fourth block (emp2) which uses the 'emp' table and join this one to 'dept_mult'. Then remove the 'relations' between 'dept_mult' and 'emp'. This way each master has only one detail and vice versa.

David
Previous Topic: How to insert data to other table which is not on the same block please?
Next Topic: [newbie] problem with non blocking show_window
Goto Forum:
  


Current Time: Sun Dec 04 16:42:14 CST 2016

Total time taken to generate the page: 0.10719 seconds