I am using the pre made contacts database and have added a field called Mailing list with six different values that have check boxes next to them. The values are artists names. The current database has a check mark next to ARTIST 1 for every contact in the database. I am now importing a list of names and after import I add a check mark to ARTIST 2 using "Replace Field Contents" This is where I get stuck.
I have a script to find duplicates... but what really needs to happen is for any duplicates it needs either combine the records that match or add a "check" in Artist 2 on the original record.
Any help is much appreciated.