Family Listing

  • Thread starter Thread starter Taso
  • Start date Start date
T

Taso

Im working on a mailing list in access, and I am trying
to make a family list, the only issue is I have siblings
and parents on the list and I am trying to figure out how
to make the query only report once per household.
Does anyone know how I can pull that off?
 
Im working on a mailing list in access, and I am trying
to make a family list, the only issue is I have siblings
and parents on the list and I am trying to figure out how
to make the query only report once per household.
Does anyone know how I can pull that off?
Click to expand...

What I've done in this situation is to have two tables: tblFamilies,
which contains the mailing address, related one to many to tblPeople.
tblPeople contains a FamilyID field as a link to the family table.

I've given a few people a free copy of my church-membership database
which incorporates this feature (together with an unlimited number of
mailing lists). Let me know if you would like a copy (and what Access
version you use if so).
 
That would be real cool if you could do that.
just remove the **NOSPAM** in my email address.

Thanks
 
Back
Top