Well not just resides but can also have onwership, as a caretaker can have ownership of more than one room as they look after many and in some situation some staff do reside in more than one.

But getting back to the original question - can the we some how get that that staff_rooms table to populate? Where it be use of VBA, form etc?