>Hi John...
>
>
>ADO actually has this problem licked.... ADO Recordsets have both a bookmark and an absolute positon property.
>
>In your case, I would suggest using a local view that uses an order by. Then, you can create an index on the field you are actually ordering by - supporting seeks. Now, the record number and the relative position in the table will be in sync.


Thanks for the reply John. Your solution will work but I was looking for a way to do it in code so I didn't have to make special considerations for the views or tables. Craig Berntson has come up with a solution that will fill the bill.

Thanks for the help