Ok here is my problem. I am converting A4V7 to A5. The client�s clerks were not the most attentive on entering data and the result is multiple duplicate entries with only slight data variations. The customer table has MANY duplicates ( some with data fields filled, some not ) and the numbers assigned to the customers are used to populate several other tables that are used to link the various tables to a customer summary set for a summary display. I define duplicates as first, middle, last name for this example. When I do a lookup by Last, First, Middle I may get the blank customer data or the filled data. I need to eliminate the empty data customers from the customer table and update the other tables with the Good customer number.
When I run the �mark duplicates� genie I get a display that may show a master with or without other populated data fields and the �duplicate� with exactly the opposite filled or unfilled data. Ex. One side will have DOB and other will be blank.
When I run the mark duplicate genie with Last, First, Middle, I get 1016 duplicates out of 16000+ records. Most of the records are NOT really duplicate i.e. different DOB etc. so it is just time consuming to go thru them unmarking those. But this leaves me with only the marked bad records and no connection to the good records.
What I need to do is generate a table that has two fields containing the duplicate customer numbers. The client will then print this list out and go thru the table verifying which record is Good and mark the Bad for purging. I will then run a update that will search the auxiliary tables and change the customer number from the Bad number to the Good number. Then I will purge the Bad customers from the table.
Any advice will be greatly apprciated by myself and the client.
Don
When I run the �mark duplicates� genie I get a display that may show a master with or without other populated data fields and the �duplicate� with exactly the opposite filled or unfilled data. Ex. One side will have DOB and other will be blank.
When I run the mark duplicate genie with Last, First, Middle, I get 1016 duplicates out of 16000+ records. Most of the records are NOT really duplicate i.e. different DOB etc. so it is just time consuming to go thru them unmarking those. But this leaves me with only the marked bad records and no connection to the good records.
What I need to do is generate a table that has two fields containing the duplicate customer numbers. The client will then print this list out and go thru the table verifying which record is Good and mark the Bad for purging. I will then run a update that will search the auxiliary tables and change the customer number from the Bad number to the Good number. Then I will purge the Bad customers from the table.
Any advice will be greatly apprciated by myself and the client.
Don
Comment