How to set the list value in the popup field
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?