Page 1 of 1

Identify Mr and Mrs

PostPosted: Sun Jan 29, 2006 12:45 pm
by Ralph
I have a fp7 database of about 150,000 individuals. Each individual has a unique record containing among other data, their last name, house number, street name, city, zip and gender.

I built a self-join relationship that, using their last name, house number, street name, city, and zip allows me to identify "Unique" and "Duplicate" individuals at a single address. Using only the "Unique" records allows me to send a single piece of mail to a particular address instead of a piece to each individual.

My problem is that I must address that piece of mail to "The BLANK" Family; very impersonal.

What I would like to able to do is send mail addressed to "Mr. and Mrs. BLANK" if there are two people living at the same address (Unique & Duplicate) and, using their gender, address the remaining "Unique" records to either "Mr." or "Ms."

Is there anyway to do this?