Mailing list question

[JoeyG54]

Can access be used to create a mailing list that categories each person in multiple groups? For example, say person A is a breast cancer patient, also a colon patient, and is interested in yoga. Can that one person be flagged for all 3? Then can a list be extracted from the mailing list of just the people interested in yoga (even though they may have other categories attached to their name)?

[June7]

Sounds like something Access is well-suited for - relational data.

Need tables:

Patients

Categories

PatientCategory
PatientID (foreign key
CategoryID (foreign key)

[JoeyG54]

I should mention I'm a new to access. I looked up how to make foriegn keys and how to setup a mailing list. Is there a simple way you can explain how to select everyone in the mailing who have a similar characteristic even though they may have multiple different characteristics tied to them.

[June7]

Use queries to select records and manipulate data. Include Join clause to get data from related tables and Where clause to filter. Access Help has guidelines on building queries. This is basic functionality covered by any introductory reference book.