View Single Post
  #1  
Old February 26th, 2005, 07:33 PM
wattog
external usenet poster
 
Posts: n/a
Default MS Access: How to group records/addresses by category/categories

I am new to Access (2002), and am reading up on it in two books. I have
also checked the online help, but can't find an answer to what I would think
would be a very basic question about categories or groups of records.

I plan to put together a MASTER address/contact list for use in a new job,
but I need to be able to group the individual records in multiple categories.
In other words, I will want to generate reports with all addresses in a
certain group, but some of the records/people from the master list will
appear in more than one group. It would be like having a master address
book, and wanting to "code" or designate a person as BOTH a business contact
and a friend contact. (Although in my case, it will coding/grouping contacts
for different committees and different events, with some individuals included
in not just one group, but several groups.

I can't figure out whether I need a different table for each group, or
whether I can code records in a table for multiple categories. If I do use
different tables for each group, how do I connect the same person who appears
in several groups, so that I will make changes to only one record that will
be reflected across all instances of that record in other tables.

I'm sorry if I am not explaining this very well!

If you have a book or online source that I need to read ... please let me
know.

Thanks!