Selecting current record value in repeated region drop-down box

***************FIXED******************

Sorry, I've fixed this issue now. I swapped the order of the recordsets around and got it to work properly that way. I'd been stuck on this for about 3 hours before posting on here, then I had a flash of inspiration and it's working. Didn't mean to waste anyone's time.


Hi,

I'm trying to build an update page that allows a user to update up to 5 products. The page has a repeat region behaviour added to a table row containing a drop-down list that's populated with product records from a single database table - that's all working fine.

However, I have another recordset on the page that selects the current product value. This recordset only ever displays the first record in the repeat region, so when I ask the dynamic drop-down to select the value that's equal to the value in this second recordset I just get the same record selected 5 times, rather than the first drop-down box selecting the first record, the second drop-down box selecting the second record etc.

How can I get it to move to the next record in the 2nd recordset so that each drop-down selects the current value?

I've attached a copy of the page.