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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top