Hello,

I would like to know if i can sort a table using (SQL?) and change the index of each row. The reason is that I refer to this index to display data, and i'd like to have it sorted.
E.g., now i use a string like "SELECT * From Customers WHERE AA=" & Cur_Row, where Cur_Row is an integer that is set programmatically, and AA field is unique index.
Is there a way? Or an alternative to overcome this?