Thanks Mike,

I'm not sure if that'll work in my situation, but I'll see if I can get any ideas off of it.

Right now, my biggest problem is how to produce a list of all possible matches for all possible customers. For 50,000 records it will take too long and probably give the user information overload!

Then after that I need to give the user a means of stating merge these records into this one.

>http://www.foxridgesoftware.com/Software/ScreenDesigns/DataMatcher/tabid/61/Default.aspx
>
>>Hi,
>>I have a system where customers get manually added regularly to a table which results in duplicate customers. I need to try and merge duplicates into one record (by merge I am just taking the last record entered or letting the user decide which one to keep and then getting rid of the other records after assigning all the customer's transactions to the record being kept). I can check for duplicates based on customer name, address, ID Card#, Phone# and I do so using a "fuzzy" matching technique.
>>
>>I am trying to create an interface that will make this work well and am getting stuck, so I'd appreciate any ideas.
>>
>>I can let the user pick one customer from the list of customers and then search for duplicates, present the duplicates in a multi select grid and let the user select the duplicate records to merge into the originally selected customer. This has the drawback of the user needing to know that a customer record has duplicates, so it won't work well in the situation where the user wants a list of all records that have potential duplicates.
>>
>>So I need to let the user do a search on all customer records and present possible duplicates for each record, then select the record to keep and then select the records to "merge" into the one to keep, bearing in mind that I may have any number of different customers that I am trying to merge at the same time.
>>
>>Is that confusing or what!? :)