Thank you so much . Am enjoying your lessons.  I have taught myself and am enjoying going through your lessons and learning all the tricks. Wish I had started with your lessons.  My database is to capture medical data. I therefore have multiple tables with a large amount of fields. I  gave each patient a unique patient number and called it the primary key in the first table where I linked it to name .  Can I now add a separate autonumber even after data has been added?   I hope to be able to split the database for data entry via forms.  Am putting all on hold while I do all your lessons as far as expert 1!!!

---

Reply from Richard Rost:

Sure... you could keep your old number, just use a new ID field for RELATIONSHIPS.