Filter drop down lists & pop up menus
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:
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.