I want to Add an Autonumber to...

[anchorp]

I have a fairly small database I recently built that includes a particular table in which I meant for the primary key to be an Autonumber field. Apparently I forgot to set it this way and it currently sits as just a Number field. There are nine tables in this database with a couple hundred records in the main tables.

Is it possible to change this field to an Autonumber at this point? I have attempted to change it and it wants me to remove all the relationships. It also seems to be necessary to copy all the records out before reseting and then copy them all back in or it will not let me proceed.

Will doing it this way work? Is there a better way to do it? Please advise. Thanks.

 

[llkhoutx]

Generally you can add an autonumber primary key, however, if it has existing relationships, you have do delete them first; create the autonumber primary key; then reset the relationships.

Welcome to the wonderful world of Access.