At 3:40 PM -0500 11/1/00, Katie Riddle wrote:
>here's my situation:
>We bought a license plate list from the state for our database. A lot
>of husband/wife couples both bought license plates, but they were
>imported as two separate records. Now, when we do mailings, we end up
>sending individual mailings to the same household-a waste of resources.
>What is an easy way to combine these separate husband/wife records? I
>tried the householding feature, but the records still came us as dupes
>(loose).
>THanks
>Katie
At 4:25 PM -0500 11/1/00, Walt Daniels wrote:
>They will be marked as dupes, but if you do the right thing when printing
>mailing labels only one will print.
To add to that: The loose dupe criterion matches last name, address
and zip code, so it will always show couples with the same last name.
To "do the right thing" when printing, go to the bottom of Query
screen 1 when selecting the set to print, and select "heads of
household or not in household". This will select only one record for
each household. Then insure that your label or letter format has the
household address included so if there are two names, both appear.
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
