Home » Developer & Programmer » Forms » regarding master-detail relationship
regarding master-detail relationship [message #214263] Mon, 15 January 2007 10:31 Go to next message
Messages: 36
Registered: December 2005
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 160 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
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.

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: Sat Oct 22 20:40:32 CDT 2016

Total time taken to generate the page: 0.11137 seconds