Dynamic Filter for Available Rooms
I am new to FMP, working with FMP version 10. I am creating a database to manage a conference. I have tables for Sessions, Participants, Presentations, and Rooms. For each session, I need to select a room for the session based on 1) the room will accommodate the estimated attendance for the session and 2) the room is available (i.e. not already used for another session.)
I have been able to set up a dynamic filter list so that when I select the estimated attendance for the session, only the rooms that have that capacity (or greater) are shown. What I'm not sure is now to structure things so that I can also see if the room is available. The conference spans three days and the time slots for the sessions are similar across the days, but not exactly the same.
I'd appreciate any direction as to how I should look at structuring this.