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

    Field Validation from Value List Not Working

    NicholasFernandez

      Title

      Field Validation from Value List Not Working

      Post

           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?

           Thanks!