|I have a database that contains two address lists. Each is identified by an indicator in a separate field to denote the original file.|
I need to be able to remove duplicates by comparing the name field and the address field of each row. When a duplicate is found I would like to populate an additional field marking the pairs so that I can remove the duplicates only from one of the files.
Help is appreciated!