Access Primary Key

[Teacher1234]

I have a Book Collection Database with three tables:

Book Collection
Book Reviews
Leveled

The Primary Key is letters (A1, A2, etc). I would like to change it to an autonumber. I about 50 records in the tables. Is there an easy way to update the primary key to an autonumber to all the tables; so doesn't ruin the information? Thanks

SD

 

[SkipVought]

Hi,

Please post MS Access questions in one of the MANY MS Access Forums like forum700.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}