I was wondering if it was possible to do Data Validation against a list of values via the infopath ui instead of setting up a data validation for each value?
For example I have a requirement that if a value of field1 is equal to a value on a list of n number of values (1, 2, 3, etc), then field2 is required.
What I've done is set up data validation conditions on the field2 that looks as follows:
IF Field2 is blank AND
Field1 is equal to 1 OR
IF Field2 is blank AND
Field1 is equal to 2
Screen Tip: Field2 Required
Message: Please enter a value in Field2
This is ok for a few conditions but i have a list of 50 values. There's got to be a better way then to write 25 conditions (since you're only limited to 5 lines to compare per conditions) on the field. I added the 25 conditions so that I could get the requirement met, I'm just looking for a better way to do this if I have a similar requirement in the future to save some time.