AnsweredAssumed Answered

Value list validations

Question asked by JohnR on Apr 17, 2018
Latest reply on Apr 19, 2018 by JohnR

I have a solution in Filemaker 15 where the contents of a field are selected from a drop down list. I have the field validation set so that it must be a member of the value list. The issue is that my value list contains values that are case sensitive and can't be changed. For example, if the value on the list is 1-A, then the field must contain the value 1-A and not 1-a. If I type 1-a, it passes validation. I can't filter out lower case because some values contain lower case letters. Is there any way to set this up so that the validation will recognize upper and lower case? A pop up menu would not be practical as my list contains over 3000 values. Help!

Outcomes