Full Version: Beginner Access Database design
UtterAccess Discussion Forums > Microsoft® Access > Access Tables + Relationships
Cheryl
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
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.