Deleting duplicate entries

[Guest]

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

 

[Brian]

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

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.