If i would like to track people by a spicific number; would I still do an auto number field but make the specific number the primary key?

---

Reply from Richard Rost:

If YOU have a specific number that YOU'VE assigned to them, then make this a SECOND field. Still use the AutoNumber to have Access assign a number to them, but you can use YOUR number as well. You want to use AutoNumbers to form the relationships in your database (we'll get into those in the Expert classes soon).  Since AutoNumbers never change, you don't have to worry about relationships getting messed up.