I want to send a report to everyone at one address...

[Bob Quintal]

I want to send one letter to the client address and list the
Beneficiaries for that address.
Each Beneficiary is attached to its own Client record. that is
how the data was imported.
I want the address once, and each of the Beneficiaries at that
address. The clients are the parents and the Beneficiaries are
the children... the children's last name may or may not be the
same as the rest of the children...

I have a Client table that look something like this:
ClientID
Firstname
Lastname
Address
City
State
Zip

I have a Beneficiaries table that looks something like this:
BeneficiaryID
ClientID
BeneficiariesFirstName
BeneficiariesLastName

Any ideas would be appreciated.

I'm using Access 2003 if it matters.

Thanks

Kelvin

create the letter as a report, based only on the client table.
Create a sub-report using the beneficiaries table, and embed it
in the main report using the ClientID field in both the lin
parent fields property and link child fields property of the
subform control.

 

[Kelvin Beaton]

I want to send one letter to the client address and list the Beneficiaries
for that address.
Each Beneficiary is attached to its own Client record. that is how the data
was imported.
I want the address once, and each of the Beneficiaries at that address.
The clients are the parents and the Beneficiaries are the children... the
children's last name may or may not be the same as the rest of the
children...

I have a Client table that look something like this:
ClientID
Firstname
Lastname
Address
City
State
Zip

I have a Beneficiaries table that looks something like this:
BeneficiaryID
ClientID
BeneficiariesFirstName
BeneficiariesLastName

Any ideas would be appreciated.

I'm using Access 2003 if it matters.

Thanks

Kelvin

 

[Kelvin Beaton]

thanks, I'll give it a try!

Kelvin

create the letter as a report, based only on the client table.
Create a sub-report using the beneficiaries table, and embed it
in the main report using the ClientID field in both the lin
parent fields property and link child fields property of the
subform control.