I'm trying to figure out the best way to create mailing lists. I have a contact database with many people. I want to be able to assign each contact to multiple mailing lists, which can then be printed. What is the best way to do this?
Should I create a table with all mailing lists on it, or should I create a table for each mailing list? I'm not quite sure about the best way to create the tables and link them.
Then, how is the best way to put the person on it - should I use a tick box or perhaps in the same manner as if I was assing a participant to a meeting group?
I know this is a basic question, but fundemental in assuring the database works properly