Table Setup in Inventory database

[Guest]

I have a database to track computer inventory in my school. Laptops are
assigned to teachers, however most other equipment is assigned to room#s. I
have all equipment listed in one table, but I want to relate it to the Staff
Table when it is assigned to a teacher, and relate to a Room Table when
assigned to a Room.

Is this possible?

 

[Al Camp]

Barbara,
Sure... you'll just have to treat RoomNos like people. In your Staff
table, you'll also list all the RoomNos (use the LastName field).
Assign a computer to a Staff person or a RoomNo.