I don't know where to begin or what to even call this method.
Basically I know the wizard is quite good at finding similar records searching for duplicates but it doesn't give you many options afterwards except delete or ignore.
i basically want a list table object to be populated with potential duplicates then either merge two similar records together (and if they have different addresses - one will become a secondary address)
or amend the record - for example if it is meant to appear twice but you don't want both to be printed on address labels for marketing (so you would untick the box used in the marketing filter)
A good starting point would be most appreciated.
Thanks
Basically I know the wizard is quite good at finding similar records searching for duplicates but it doesn't give you many options afterwards except delete or ignore.
i basically want a list table object to be populated with potential duplicates then either merge two similar records together (and if they have different addresses - one will become a secondary address)
or amend the record - for example if it is meant to appear twice but you don't want both to be printed on address labels for marketing (so you would untick the box used in the marketing filter)
A good starting point would be most appreciated.
Thanks