4 Replies Latest reply on Feb 19, 2014 9:41 PM by NicholasFernandez

    Field Validation from Value List Not Working



      Field Validation from Value List Not Working


           Hi All,

           I've been using the following If statement (courtesy of PhilModJunk) to check if a value is a member of a value list from a field in another table:

      not IsEmpty ( FilterValues ( ValueListItems ( Get ( FileName ) ; "Master Source List" ); ${Start-Up DB}::Source ) ) = False

           This worked fine for a couple of weeks, but now it is returning many false negatives. The Value List shows up properly as a drop-down list in the field I want to validate, but if I select one of the drop-down items, the validation script states that the name is not listed in the Value List.

           Any ideas why this would change?