Floor Maps

[neo651]

At my company we track all rooms of all offices in our database. I have 2 tables for this, tblOffices and tblLocations. tblOffices is the 10 offices in our company and tblLocations is, more or less, the rooms in each office. We also have floor maps for each of these locations. It's not uncommon for rooms to be repurposed but we give them names descriptive of what the room is used for. As a result, whenever a room gets repurposed I need to update both the floor maps and the database. Is there anyway to combine these steps? Say by having a report that takes the names of all the locations in an office and lays it over a jpeg of the floor map?

Thank you.

[hertfordkc]

https://www.accessforums.net/forms/h...ion-18019.html