Hi!!

I've created a table in access with a primary key and 10 records. If i want to change the order of the records for example the record number 8 i need to be record number 1, i change the record number 8 id to 11 (so i wont get and error saying that id already exists), then the record number 1 id to 8 and finnaly the record number 8 id to 1. But if in my table i dont have a id columm and NO primary key how can i change the order of the records???

By the way the Database format is Access 2000.