Jump to content
Sign in to follow this  
bayoyong

Letters to Families Not Individuals

Recommended Posts

I have built a database for our church, and I’m trying to create a system where we can print either envelopes or letters to go to our members. I have created separate records for each person and a field called “family id” (a number) for each family.

Now all I want to do is find husbands and wives and put them on one envelope/label (instead of sending a letter to the wife AND the husband).

Is this hard? Seems like it should be basic. But I can’t figure out how. And I’ve searched boards, watched tutorials. But to no avail.

Can you help?

Thx either way.

Jeff Krieger

Phoenix, AZ

Share this post


Link to post
Share on other sites

If you seperated the addresses and people into their own tables then you can do it. In this case, a simple one to many should be sufficient unless you plan on tracking multiple addresses for each contact as well. The relationship would be for each addresses, there are multiple contact.

Then when you print, you would print from the addresses table while addressing the contacts in your salutation.

Share this post


Link to post
Share on other sites

Is the address information stored in the Family table?

Are there children in the Member table? If so, what if a child is an active member, but the parents are not? Should the child get the mailing or the parents?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.