Deleting duplicates in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing SQL code to delete duplicate records 0
Duplicate values 4
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Deleting duplicate entries 1
Data entry creating duplicate rows in table 3
Duplicate Records Problem 2
Access Compare records in same access table 0
DELETE FROM a table WHERE... 1

Back
Top