1 of 1 people found this helpful
Does this help?
Search for 'FileMaker Conditional Value List' and you'll get more examples, blogs and articles.
Read about conditional value lists as beverly suggested.
One way that will work is add a global calc field in the EmployeeDetail table and set the calc value to "active".
Create a second table occurrence of EmployeeDetail table, "EmployeeDetail 2". Relate EmployeeDetail 2::GlobalCalc to EmployeeDetail::Status.
In your value list setup Include only related values from EmployeeDetail 2.
There are other ways but this will work. It would likely be better to have a table with one record for these kind of global fields, but I think you will get the concept.