how do i create a distribution list by using a certain category? Can the
distribution list automatically show the members the category? Or di I have
to input each member onto the distridution list.
If each person can be on many lists, and each list consists of
multiple people, you need three tables: a table of People (with a
unique PersonID, LastName, FirstName, address information, etc.); a
table of Lists, with ListID, ListName, and any other information about
the list as a whole (perhaps distribution frequency); and a table of
ListMembers, with fields for the PersonID and the ListID.
You'ld use a form with a subform to add people's IDs to the
ListMembers table (uaing a combo box to select the person's ID),
and/or a form based on the People table with a subform based on
ListMembers, with a combo box to add lists.
You'ld then create a Report based on a query joining all three tables,
with a criterion to indicate which list you're printing.
John W. Vinson[MVP]
