Richard, thank you for the very helpful tutorials.  My question is why do you always use Autonumbers when creating new tables when you could use Indexed (Yes, No Duplicates) from your primary description instead?  Autonumbers can be hard to connect to multiple tables and allows for duplicate entries.  Thanks.

---

Reply from Alex Hedley:

Why are they hard to connect to multiple tables? If you set up your relationships correctly and the Forms are configured properly Access handles all of that for you.
When you set the Foreign Key on another Table you can set up No Duplicates in the table so you wouldn't create more than one entry for that