Create a new table identical to your existing table, except make the number
field an AutoNumber.

Append the existing table to the new table.

The next value for the AutoNumber field will be one more than the largest
value already used.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Patttt" wrote in message
...
I have an existing table that has a number field as the primary key. I want
it to replicate the autonumber feature by adding the next number in
sequence
when a new record is added, but I can't change it to an autonumber field
and
keep the existing data. Can it be done? Thanks! Pat