I have a database where almost daily customers get deleted seemingly automatically, and Autonumber IDs get duplicated. This is all in only one table. Autonumber field is CustomerID(Indexed - Yes (No Duplicates))
The weird thing is, is that it is not related to new customers, these are customers that are halfway through the database. The customers that get deleted may or may not have related records. If I try to delete a customer manually, I cannot because there are related rcords. So this is a bit of a mystery. Records that are not supposed to be able to be deleted are, and CustomerID's that are not supposed to be duplicated are.
The weird thing is, is that it is not related to new customers, these are customers that are halfway through the database. The customers that get deleted may or may not have related records. If I try to delete a customer manually, I cannot because there are related rcords. So this is a bit of a mystery. Records that are not supposed to be able to be deleted are, and CustomerID's that are not supposed to be duplicated are.
