FM11Pro Removing duplicate records...

[Helmutek]

Hi, I've been running around google, filemaker knowledge base, and everything else for that matter and still can't find an answer to this... or at least not as easy as I thought it would be.

Scenario is; I have FM11Pro, and imported a file with 40,000 records. This is my mailing list database, and every bit of data is separated into columns. What I'm trying to accomplish is select and delete duplicates based on two columns (because a lot of the addresses are duplicated simply because there is an entry for every member of the household).

It looks a little something like this;

Mr. | John | Smith | 123 | Main | Street | City | State | Zip

Ms. | Ana | Smith | 123 | Main | Street | City | State | Zip

So ultimately I would like to send one piece of mail to only one recipient per household, and I don't really care which one is selected mr., or ms. as long as get don't spit out duplicates for obvious reasons of being cost effective.

Please also direct me to an appropriate channel if I posted this in a wrong one.

Thanks in advance for responding to this.

[Fitch]

http://fmforums.com/forum/showpost.php?post/361086/