Am trying to allow user to change the sort order in a grid by changing the order property in the data environment for the primary table. While this works, the system won't keep the current record. I'm saving the pertinent information so I can seek after the change, but no luck. I always get an offset from the original order.

ex: change key on first record stays on first record.
change key on 2nd record and jump to record immed. after original record in new order.
change key on 3rd and jump to 2 records after original record in new order.

any ideas?