Here's my problem.
I have a drop-down box in a repeating row that has it's result set filter based on what's entered in the previous text box. It does this all correctly and submits correctly, but when the form is reopened it resets all values in the drop downs to the first value in the result set.
Example.
In row 1: You enter work order 222 in the text box and there are three items in the drop-down you can select (A, B, C) related to that work order. So I select B
In row 2: I again enter work order 222 in the text box. Then I select item C in the drop-down.
I submit the form fine but when I open it again it resets all values in the drop-down to A, the first item in the drop-down values.
I'm thinking that perhaps I can disable recalculation on the drop-down once a value is selected? How can I disable this through code. Or perhaps someone has another suggestion?
Thanks!