UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Beginner Access Database design    
 
   
Cheryl
post Feb 23 2004, 05:10 PM
Post #1

New Member
Posts: 1
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.
Go to the top of the page
 
+
BrianS
post Feb 23 2004, 05:18 PM
Post #2

UtterAccess VIP
Posts: 5,597
From: St. Louis, MO
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.
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 02:35 AM