One issue to consider is that usually, your program should not rely on the records having a specific physical order. For one, this makes it difficult to upsize to a C/S solution; a database server won't have the equivalent of a recno(), and will rely exclusively on primary keys, etc.
However, having the records in a certain order can sometimes improve performance.
>I hate to pack tables because after doing so the data is not in the order it was created. All my tables use a guid for the PK so I believe after they are packed they are in order by the guid.
>
>I know I could always set order to transactiondatetime (example) but when I just USE the table and then BROWSE it, I'd just like it to be in the same order it was in before the PACK.
>
>Is there a way?
>
>Thanks,
>John
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)