Home » Developer & Programmer » Forms » choosing master and detail
choosing master and detail [message #78891] Wed, 27 March 2002 16:29 Go to next message
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 Go to previous message
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.
Previous Topic: installation
Next Topic: OLE2 Excel Chart
Goto Forum:
  


Current Time: Thu Mar 28 15:54:41 CDT 2024