Relationships for tracking households/families

[lhpac via AccessMonster.com]

Hello all. We are a theater/performing arts center.
I am trying to track clients that attend our events, classes and also donate.
We would like to be able to identify households which may inlude one or two
heads as well as children, and be able to customize class brochure mailings,
theater show mailings etc. The problem is that we do not want to mail
flyers/brochures to children for things that are not appropriate for children.

Also, we don't want to mail requests for donations to children. In addition,
we need to be able to track donation amounts and services that our clients
use.

The other issue is how to track the ages of the children over time -
calculating age.

I don't understand how linking a table to itself works and if it will fit my
needs.

 

[John Vinson]

Hello all. We are a theater/performing arts center.
I am trying to track clients that attend our events, classes and also donate.
We would like to be able to identify households which may inlude one or two
heads as well as children, and be able to customize class brochure mailings,
theater show mailings etc. The problem is that we do not want to mail
flyers/brochures to children for things that are not appropriate for children.

Also, we don't want to mail requests for donations to children. In addition,
we need to be able to track donation amounts and services that our clients
use.

The other issue is how to track the ages of the children over time -
calculating age.

I don't understand how linking a table to itself works and if it will fit my
needs.

I've got a database (developed as a church membership database) which
might meet your needs. It has tables for Families, Members, and
Activities, with a many to many link from members to activities. You
could use an Activity as a mailing list and assign whomever you wish
to it.

Drop me an email at jvinson <at> wysard of info <dot> com (edit out
the blanks and put in the punctuation) if you would like a copy.

You can calculate age by storing date of birth; in a Query you can use
a calculated expression

DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "y") >
Format(Date(), "y", 1, 0)

John W. Vinson[MVP]

 

[Allen Browne]

John Vinson's generous offer of giving you a copy of his database will be
the reply you could get.

If you are interested in exploring options, you might also like to read:
People in households and companies - modelling human relationships
at:
http://allenbrowne.com/AppHuman.html