I have a new database that contains a table called Table_PartNumbers. It contains a list of all the part numbers with all of our customers. In my initial data entry I accidentally duplicated 4 part numbers.
Can I just delete the records from the table (select then delete) or should I get rid of them by creating a Find Duplicates Query, convert it to a Delete Query and take care of them that way?
At this point nothing bad will happen to my database if I just click and delete the 4 extra records. All the part numbers have a unique ID and the database is so fresh that there aren't any records in any other tables that reference the duplicates.
But, since I'm trying to learn 'proper' technique this go around, I was wondering what proper steps should be followed?
I found this link below but I just don't quite understand if this something you always want to do or it is okay to just delete records if there is no chance of database corruption?
https://www.accessforums.net/access/...ete+duplicates
Thanks.