To set up a value list of only active employees, try this:
1. In Employees, create a field, called z_one, and make it a calculation = 1. Important: make sure it is an unstored calculation.
2. Create a second table occurance of Employees, called Employees_ActiveOnly.
3. Create a relationship between Employees and Employees_ActiveOnly, using these fields: Employees::z_one = Employees_ActiveOnly::Active.
4. Set up your value list called Active Employees. Use values from the field Employees_ActiveOnly::Name. Select the "Include only related values starting from:" and select Employees.
5. The value list Active Employees is ready to use!
Please note: if you actually want to store the Employee's Record ID instead of their name in fields that use the value list in a pop up or drop down, you'll need to set up the value list to use values from the first field Employees_ActiveOnly::Record ID and also display values from Employees_ActiveOnly::Name. The "Include only related values" remains the same, but you may want to check the "Show values only from second field" box.
This is how I've always handled similar situations, but maybe someone can suggest a better way?
A simple method to create your value list would be to make a calculation field Active_Name = If ( Active ; Name ) and base your value list on that. No need for extra relationships.
Thank you that was very helpful