I'm designing an InfoPath 2003 form template. It contains a repeating section with a drop down list in it and can contain anything from 1 to x rows. Each drop down list can be set to one of two values: "Approved" or "Rejected".
I want to put a check box at the bottom of the form that will (when ticked) set all the drop down lists that do not have the value "Rejected" to the value "Approved". So I have added the following rule to the check box:
Condition: checkbox=TRUE AND status!="Rejected"
Action: Set a field's value: @AuthStatus="Approved"
However, when I load a form and set one or more of the drop down lists to 'Rejected' and then tick the box, all the drop down lists are set to 'Approved', not just the ones that are not set to 'Rejected'.
Can anyone guide me as to where I am going wrong?
Mark.