How do I link 1 record (user) to many fields (blds they resp for)

M

Morag Gibson

I asm creating a database which lists a number of people. Each of those
people is responsible for many buildings.
Within my table I would like to enter each person and then a list of the
buildings they are responsible for and then link this to another table which
give the building descriptions.
What I don't know how to do is within "one table" do a one to many
relationship
 
R

Rick B

You don't do it in ONE table. You do it in THREE.

tblPeople
EmployeeNumber
FirstName
LastName
Phone
etc.

tblBuildings
BuildingNumber
BuildingName
BuildingAddress
BuildingCity
BuildingState
etc.

tblPeopleBuildings
EmployeeNum
BuildingNum




Each person would have one record in tblPeople. Each building would have
one record in tblBuildings. The third table would contain one record for
every combination of people and buildings.

This is a classic many-to-many relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
New computer, how do i move outlook 365 ENTIRELY? 0
A many-to-many challenge 1
when to use many-many relationships or different data bases 10
Assistance with Many-to-Many Relationships 6
Copy previous record into form field 0
Multiple Many-to-Many relationships 10

Top