Cheryl
Feb 23 2004, 05:10 PM
I need to design a database for: Management of Mandatory Training items due/complete(associated w/a tittle 4 tittles in all) throughout the year for Employees (unique id and common tittle) at 5 different locations.
i can set up the tables and make common relationship querys and reports, but i can not figure out how to make the many to many relationship. Can anyone help me...i need to present to mgt asap. thanks cheryl.
BrianS
Feb 23 2004, 05:18 PM
For a Many to Many relationship you need 3 tables. Essentially you will be creating 2 one to many relationships. Here is an example Many People can live at one Address and One Person can have Many Address
tblPerson
-PersonID (Primary Key)
tblAddress
-AddressID (Primary Key)
tblPersonAddress
-PersonAddressID (Primary Key)
-PersonID (Foriegn Key)
-AddressID (Foriegn Key)
All of the ID fields are autonumbers.