1 Reply Latest reply on Jun 13, 2011 9:05 AM by philmodjunk

    Filtered value lists

    greenex

      Title

      Filtered value lists

      Post

      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.