InfoPath Dev

I have a repeating table that includes a field called Reason, from which the user selects from a drop down list. If the user has selected "Other" as a Reason in any row of the table, I would like to trigger the ValidationRule on the form's Explain field. (The Explain field is not in the repeating table.)

See attached sample. Save it locally and then right click & select Design, from there you can preview. There's an option when selecting from repeating fields once outside the repeating node - you can choose "any occurrence", "all occurrences" etc. There's a screenshot in the sample form that should help you find that option in your form. :)

Wow. Thanks, Hilary. After I posted the question I continued to work on it for several more hours and finally cobbled together this formula: contains(xdMath:Eval(xdMath:Eval(../my:ProductGroup/my:Item, 'concat(my:Reason, ";")'), ".."), "Other") Your way is much easier. I never noticed that dropdown list of "Any occurrence of..." etc existed! Thanks again!!

I used InfoPath for YEARS before I noticed that dropdown. It really does make building this kind of condition a lot easier. :)