Filter Drop Down List

[blakey1978]

Hi

I am new to fmp.

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 select the locker 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