AnsweredAssumed Answered

Filtered Value List not working as Planned

Question asked by user22711 on May 19, 2014
Latest reply on May 20, 2014 by philmodjunk


Filtered Value List not working as Planned


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.