I have now posted my question as a new thread - don't want to confuse my
request with the original.

lhpac wrote:
Hello all. I also have a similar design problem. 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.

The way this family relationship is handled in a normalized schema is with a
self referencing table. An autonumber is used as the primary key. A field
[quoted text clipped - 26 lines]
Thanks in advance for your help. Any suggestings or comments are greatly
appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200603/1