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 170 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: Surges Bay TAS 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: problem while design a column in graphics builder
Next Topic: if down arrow key is pressed, detail block window is displayed
Goto Forum:

Current Time: Sat Aug 19 19:35:20 CDT 2017

Total time taken to generate the page: 0.32580 seconds