Title

Filtered Value List not working as Planned

Post

A flag in the Employees table set the staff members as a Department Manager (Checkbox = 1). In a separate table, I am looking to create a value list that just displays managers for the related departments. All the conditional value list examples I have found are bit different… Drop Down selection 1 results in drop down 2 choices being filtered, etc.

I created a calc field Managers_c

If (Staff::is_manager_f = 1; Staff:: Name_Full)

But the calc field cannot be indexed and the warning prevents the value list from being created.