I am glad to say that I have solved my problem. In case anyone is interested this is how.

I set order on the cursor to my mydex field then set a relation between the two tables and then ran the same update command and it works great.

Thanks for the input everyone.

Matt