re-ordering database

[hindu]

How do you insert records in to a database with numbered feilds and have it re-order itself

 

[elizabeth]

The db does not actually reorder itself physically, and you don't actually insert the record. Access always adds new records to the end of the file. When you read the records, you simply read them in order of the index(es) you open the record set with. If you use the Autonumber type, Access automatically adds each new record with the next sequential number. Each time you add a new record through the GUI, you update the related indexes as well. If you add a record through code, you open it using the indexes and Access updates the indexes for you. <br>
<br>
Hope this helps.