Barbara Ryan
BarbaraRyan at cox.net
Wed Feb 28 12:30:16 CST 2007
I am designing a new Access database for a therapeutic equestrian riding facility. The database holds names of all the "partners' (individuals, groups, and companies) who volunteer, donate, and/or ride horses. This database will primarily be used for mailing thank you notes, information about upcoming events, etc. Each "partner" will have a mailing address and (optionally) a billing address. Many partners will share the same mailing address (e.g., handicapped individuals who live in a facility, or a family where mom and dad are volunteers and their child is a rider). Selection of partners for mailings needs to be very flexible --- sometimes a mailing is "one per household" --- however, each rider in a facility should receive a separate letter. Sometimes mailings will only go to donors and volunteers; sometimes just to riders, etc, etc. Would you split addresses into a separate table or include mailing/billing address information in the Partners table (and provide a mechanism to "copy" an address from an existing in the same household)? Thanks, Barb Ryan