Deleting duplicate entries

H

Hilary B

I created a field as number, with Indexing set to Yes and No duplicates.
This works fine if I enter two records with the same number, but if I delete
a record, it then lets me use that number again and I don't want it to. The
field must remain unique even if the record is deleted. Thanks
 
B

Brian

Hilary B said:
I created a field as number, with Indexing set to Yes and No duplicates.
This works fine if I enter two records with the same number, but if I delete
a record, it then lets me use that number again and I don't want it to. The
field must remain unique even if the record is deleted. Thanks
Click to expand...

Don't allow records to be deleted. Instead, add a field to the table to
indicate that a record is inactive, or suppressed, or whatever you want to
call it.
 
Top