Duplicating and Self deleting Autonumber ID 1

[cabrio]

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.

 

[KenReay]

Hi

On the subject of unexplained deletions, do you have a relationship set on the CustomerId, if yes, have you got a cascade delete on it?, could it be that you have it set so that deletion of a transation record, causes parent to be deleted? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK