This content has been marked as final. Show 2 replies
You can create an unstored calc with the string "Active". Then you can use a self join to have a relationship keyed from this calc field to the Status field. Now create a value list based off that relationship.
Or, create a calculation field that says [case ( status = "Active", employee )], and use that as your value list field.