2 Replies Latest reply on May 20, 2014 6:47 AM by philmodjunk

    Filtered Value List not working as Planned

    user22711

      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.