Search results

Hi All, I'm new to access, totally new! I'd like to make a database of all the rooms in my building. However we have users who use multiple rooms. What I would like is a system where I can search for, say room42 and get a list of all the people who are allocated space in that room, and again...