| choosing master and detail [message #78891] |
Wed, 27 March 2002 16:29  |
Anthony
Messages: 48
Registered: September 2000
|
Member |
|
|
In creating master/detail relationship, actually, is there any rule that saying which one should be master or which one should be the detail?
If let say, the question is to create a master detail relationship between DEPT and EMP. But they never mention which one should be the master or detail.
Thank you
|
|
|
|
| Re: choosing master and detail [message #78900 is a reply to message #78891] |
Thu, 28 March 2002 03:14  |
Susan
Messages: 102
Registered: October 2001
|
Senior Member |
|
|
|
A master-detail relationship is based on a one-to-many table relationship. The master block is based on the "one" table and the detail block is based on the "many" table. In your example, if one department has many employees, you should be able to create a master-detail form based on a master block (call it DEPT_block) based on the DEPT table and a detail block (call it EMP_block) based on the EMP table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
