MS Access Table Design?

[multipleintell]

I want to keep track of employees that work in multiple buildings. Some staff members are only at building A. Some are only at building B. (I have a total of 10 buildings). How do I build a table that is related to my EmployeeInfo Table that would allow me to say Joe Schmoe is at building A and B? I do not want to keep the names of both buildings in a single field. I would appreciate any advice you could give. Thank you.

 

[iejerry]

Are some at both?

 

[Maquis]

I would create an Employee Location table with fields: EmployeeId and BuildingId plus any other relevant fields(days at building perhaps). If an employee works at more than 1 location then that employee would have multiple records in the table. For example.

EmployeeId LocationId
----------------------
1 BldA
1 BldB
2 BldC
3 BldA
4 BldA
4 BldD


Maq B-)
<insert witty signature here>