Deleting duplicates in a table

H

Hilary B

Sorry if I have posted this before, not sure if it logged. I have a field
set as Number with Indexing Yes and No duplicates. When I delete a record I
can use that number again and I want not to be able to use the number again
Thanks
 
L

Lynn Trapp

One way you can do that is to use an AutoNumber field. When a number is used
and deleted it will not be used again. However, if this is not ideal, then
you should probably rethink whether or or not you want to actually delete
the record or, instead, simply disable the record. You can easily add
another field to your table called Enabled and set it to No when the record
is no longer valid.
 
Top