AnsweredAssumed Answered

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

Question asked by pademo57 on Jul 14, 2016
Latest reply on Jul 15, 2016 by PSI

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.