AnsweredAssumed Answered

Field Validation from Value List Not Working

Question asked by NicholasFernandez on Feb 18, 2014
Latest reply on Feb 19, 2014 by NicholasFernandez


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?