Thousands of records; merging equal companies but different ecord contents
We have the challenge to merge thousands of record of companies that where approached for marketing activities. In this big big database of over 200.000 records there are many 'almost' dupes; only the approach date and approach format (e.g. Direct Mail, Call centre call) is different. How can we 'script' towards one record per company with multiple fields within one record to hold the subsequent contact dates and form?