2 Replies Latest reply on Jun 10, 2010 3:04 AM by LaRetta_1

    Filter drop down lists

    blakey1978

      Title

      Filter drop down lists & pop up menus

      Post



      Hi 

      I am new to fmp and have traditionally used access for my various projects.

      I am designing a database for a sauna to check people in and to charge drinks ect to their key number.

      I have 2 tables: 

      [Lockers]
      LockersID
      LockerNo
      CheckedIn (Yes/No)

      [CheakIn]
      CheckInID
      DateIn
      TimeIn
      Locker

      I have a pop up menu to assign a  locker to upon arrival however i want to filter this pop up so that it filters to only show lockers whos checked in value = no.

      Now if I was using access i would do it via a query but can't see how to do it in fmp.

      ultimately I will have scripts set up to automatically toggle the CheckedIn when the client checks in/out.

      I hope this makes sense ad many thanks in advance for any help given.

      Regards 

      Dave