Thanks Naomi,

the screen shots and code would be most appreciated. I'm really just trying to picture how this would work, so not being able to run it shouldn't be a problem.

>Frank,
>
>At my former job I created an application called De-Duper (well, to be precise, I inherited it from my colleague Mike Asherman and then finilized and enhanced). I can send you some screen shots tomorrow, if you'd like.
>
>Basically, the idea was to use grid and different colors to higlight duplicate records. Then you can merge them using click and right click (I believe right click was used to finalize if we wanted multiple records to merge)...
>
>I can also probably send you some code (convert form to a code), but you would not be able to run it (since you don't have all our framework classes), but you may get some idea...
>
>>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!? :)