Identify Mr and Mrs
Posted: Sun Jan 29, 2006 12:45 pmI 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?
Ralph[/b]
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?
Ralph[/b]