| regarding master-detail relationship [message #214263] |
Mon, 15 January 2007 10:31  |
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 1010 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  |
 |
djmartin
Messages: 10181
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.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
