Filtered value lists
Bear with me, I'm new to FileMaker...
I have a database with two tables, a Contacts table and a Tasks table.
The Contacts table contains a field "IsEmployee" that is a Yes/No to determine if the contact is an employee.
The Tasks table contains a field "AssignedPerson."
I know how to make a value list of names from the Contacts table, but I would like to make a value list for "AssignedPerson" that is a name from the Contacts table and is an employee (IsEmployee = Yes).
The end result is to be able to select from a list and assign tasks only to employees and not other contacts.