Deleting records

  • Thread starter Thread starter Lori LeRoy
  • Start date Start date
L

Lori LeRoy

I have one table with 100k + part numbers that is linked
to my order table. I want to delete the numbers that are
not being used to reduce the size of the table, but when I
did this in a test environment, it deleted all the
numbers. Any ideas on how to delete just the numbers not
being used anywhere else?
 
Hi Lori,

The first question would be; how would you know which part numbers are no
longer used?

How did you determine that the part numbers weren't being used?

The next question would be; when part numbers are selected for use is the
part number, description, etc. stored in the record being created or just a
pointer to the part's record in the table. If the latter you may not want
to delete them.

What did you do to delete the unused part numbers. That may provide the
clue as to why they all got deleted.

100k records doesn't seem terribly large. What's your motivation for the
housecleaning?

HTH
 
Hi Larry -
I imported a large amount of part numbers when I created
the database and it turns out that out of the 100K that I
imported we have only used about 10k of them. Due to the
large number of records, when a user is trying to select a
part number inside a form, the drop down maxes out around
the "M's" and they cannot see any part numbers after
that. The order table is linked to the p/n table via the
relationship table. So I thought that would allow me to
delete records that were not linked - but it delete those
too.
 
Back
Top