I am building a db in Access 2000 to house records of incoming support calls. DB will support a max of 15 users. I need to generate an auto-number as a unique identifier for each record, & be able to pull up record to edit using the auto-number later. All records will be housed in a single table.
If multiple users are adding records to table at the same time, how I can ensure a unique auto-number for each record? Can number be assigned as primary key to auto-find when entered in edit form?I have done this kind of find/edit via a form with user-assigned identifying numbers, but need to auto-number in this instance.
I have moderate Access experience, but no access to other development tools & limited testing capabilities. Any advice?