10 Replies Latest reply on Jul 15, 2016 9:30 AM by PSI

    Showing Only an Employee Type in a Drop Down List or Pop-up Menu


      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?


      1. SELECT Id, NameFirst, NameLast,
      2.   FROM Employee
      3. 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.