I use a database along with 10 other people. If we try to enter data at the same time to the same IDNumber (primary key auto number), we get the RunTime Error 3022.
"Run-time error '3022': The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again
Is there a way around this? Perhaps that whenever someone wants to add a New Case to the entry form, they hit a button called "Add New Case" which creates a new record that is NOT currently in use?