Re: Custom Primary Key
Have the autonumber as your primary keys to link any relationships.
Create your 'dummy' key to please your boss and be more visible/familiar to the users, but at the end of the day it is the autonumber that does all the work in the background.
This question has been asked before in one form or another. How/When you decide to 'reset' it, is up to you/
Access novice. Sometimes trying to give something back.