AnsweredAssumed Answered

Filter drop down lists

Question asked by blakey1978 on Jun 9, 2010
Latest reply on Jun 10, 2010 by LaRetta_1

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















Outcomes