in general, I recommend to have the very same contact only one time in the db. AM stuff can be handeled in related tables
since the situation is as it is, You could get a virtual list, ie using SQL ('select distinct' will get no doublettes). You get the records in a (large) text block that can be used to create individual records in a helper table (using FileMaker's list functions) - for creating mailings.
there is more info available for virtual list with FileMaker, needs some 'browsing/studying'
thanks Marcus I will have a look at virtual tables. I also agree with your
general remark but that would mean a general overhaul. something for the