Autonumber Trouble!!!! 1

[blindlemonray]

Can anyone Help? I have a DB where there is a "number" field which is used as the primary key, but also as a reference number for the customer.

I need to change the field to an "autonumber" field so that when more records are added they will have unique ref number.... but keep all the current reference (primary key) numbers as they are attached to all the current records!!!

Can this be done? or am I just dreaming!! Any help on this would be much appriciated!!

 

[lupins46]

In the database window, copy the table - structure only.
Chnage the field definition of the key field to autonumber.
Create an append query based on the old table and append everything to the new table.
Run the query.
Rename the tables.

The autoniumber will carry on fron one later than the highest number you used before.