2 Replies Latest reply on Jul 14, 2013 1:56 AM by GuyStevens

    How to set the list value in the popup field

    TaylorJansen

      Title

      How to set the list value in the popup field

      Post

           I am new to FMP, I was using MS Access before.

            

           I have a table having the following fields: Person ID, Full Name, Category

           There are 3 categories: Student, Teacher, Relatives

           In an other layout I want to have a popup field to choose a person whose Category is Teacher. 

           I know to put the first field as Person ID & the second one Full Name. My question is how to set the condition to filter out only Teacher from the whole list?

           Many thanks!