Access Primary Key

[literacyteacher]

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

 

[PWise]

Add new autonumber field to books table[bookid]
add to rewiew table field [bookid]


join books to review on old primary key

update review.bookid=books.bookid