Hello, I built a simple database for a friends dog boutique so she could keep track of her customers.
She told me that when she goes to add a new contact that she receives a message that the record cannot be added because it duplicates an existing index. Looking at her customer table I noticed that when a new record is added the autonumber that is being inserted is a number that has already been used. For instance there are 436 records in the table, and the new record I tried to add had an autonumber of 18. The field is set to increment.
Any ideas on how to fix this (and keep it from happening again) would be appreciated. Thanks