Add AutoNumber field

[esskaykay]

I have a table that I would like to add an AutoNumber Record_ID field to. However, I want the records to be number in a specific order based on a third field called ORDER. I tried alphabetizing the table based on ORDER and saving. I reopened the table and it is in the correct order. I modified the table adding my Record_ID field. However, when I open the table, the ORDER field is not set in the order based on my ORDER field (I know, sound confusing). Basically, what I want is to add an AutoNumbner field ordered in a specific way. Is this possible?

Thanks,
SKK

 

[Galaxiom]

Ordering the existing table only changes the display order not the record order.

Copy your existing table and paste it (structure only) to a new table. Add the Autonumber field if necessary. Then append the records to the new table ORDERED BY the Order field.

 

[gemma-the-husky]

but it is wrong to expect an autonumber to have any meaning at all. an autonumber just guarantees a different number.

if you want a particular sequence, then you DONT want an autonumber - you want a mechanism to issue appropriate numbers.

 

[esskaykay]

10-4

Thanks,
SKK