I know how to do this in other languages but can someone help me translate a SQL statement (shown below) into a drop-down list or Pop-up Menu in Filemaker?
- SELECT Id, NameFirst, NameLast,
- FROM Employee
- WHERE Status IN ('Teacher')
I guess what I'm asking is how to make a 'WHERE' statement in Filemaker show only (in this case) Teachers and their names in a list.