AnsweredAssumed Answered

Filtered value lists

Question asked by greenex on Jun 11, 2011
Latest reply on Jun 13, 2011 by philmodjunk


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.