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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Morag Gibson - 21 Jul 2005 10:34 GMT

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

Reply to this Message

Rick B - 21 Jul 2005 14:34 GMT

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.

Signature

Rick B

> I asm creating a database which lists a number of people. Each of those
> people is responsible for many buildings.
[quoted text clipped - 3 lines]
> What I don't know how to do is within "one table" do a one to many
> relationship

Reply to this Message