3 Replies Latest reply on Apr 6, 2010 2:04 PM by PROFT

    Dynamic Filter for Available Rooms



      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.



        • 1. Re: Dynamic Filter for Available Rooms

          Not knowing your existing structure it is hard to respond...


          Where are you holding the Room occupancy info? I would assume you just added a Room field to the Sessions table.


          I would also hazard a guess that Sessions have a start and finish time.


          If all this is true, you could do a find for a the start and finish times of your required session and anything between, no records means its available.



          • 2. Re: Dynamic Filter for Available Rooms

            I'm not sure if you are using a portal or a conditional value list for this but the underlying concept works the same way. You simply add more fields that compare the information on the room's availability as part of the relationship definition. Exactly how you do that depends on what fields you use to "book" the room for a given session.


            If you post a little more information here, we can probably suggest a more detailed solution. Try listing each table involved and define the current relationships you use to link them.

            • 3. Re: Dynamic Filter for Available Rooms

              It ended up being a problem with the way the relationships were set up.  I found the information I needed in a posting on creating invoices that had a layout similar to what I needed.