Table containing ID field on following format:
GEF001
GEF002
.
.
.
GEF800
I'm wanting to add a new autonumber field to the table but want the table to be ordered by the existing ID field before adding this new field. Right clicking on the field in Datasheet view, order the ID field in Ascending order, save and go to the design view. Open back into design view, everything looks good, still ordered. Back to design view, and add an autonumber field. Save and return to datasheet view, it's no longer ordered and the autonumbers don't match up with the older ID field....
Any clue as to why?
BTW, this kinda relates to my other questin in the Tables forum.
GEF001
GEF002
.
.
.
GEF800
I'm wanting to add a new autonumber field to the table but want the table to be ordered by the existing ID field before adding this new field. Right clicking on the field in Datasheet view, order the ID field in Ascending order, save and go to the design view. Open back into design view, everything looks good, still ordered. Back to design view, and add an autonumber field. Save and return to datasheet view, it's no longer ordered and the autonumbers don't match up with the older ID field....

Any clue as to why?
BTW, this kinda relates to my other questin in the Tables forum.