I would like to create a value list that only displays the employyes that are active.
probably easiest would be to create a calculated field in the employees table.
to make a "calc_activeName" field:
if (activeField = "X" ; employeeName ; "" )
Then you make your value list out of this new field, and it trims out the empty values of people that are not "X".
I didn't know that the list of values trims out the empty values.
Retrieving data ...