I work for a school and all of my student records are associated with their student state ID.  It seems to me that I would want to have the releationahip between tables exist with that ID not the key ID.  Does that sound reasonable?  Or will I create prolems by not using the primary key/auto number?

---

Reply from Richard Rost:

As I've said in my videos many times, I would still use an Autonumber ID for the relationships in the database. If you want to have that Student State ID saved in the student's record, that's perfectly fine too. You can search or sort on it whenever you want. Autonumbers are just much better and easier for relationships. Nothing wrong with having two fields.