What is the best approach if you are creating a mailing list and you have multiple people under the same address or you have the same person that has multiple addresses (vacation home). If I need a record for each person in the family to track birthdays but I want to be able to send a single mailing for the entire family for a holiday card, how should I set up the database? Do I create separate tables (1 that includes names and birthday's, etc.. and another that includes addresses) and create a relationship between the two tables or can I include all of the information in a single table and there is a way that I can indicate which address it should go to or when its a single mailing to multiple people.
Reply from Alex Hedley:
I'd have separate tables, you could then have an AddressID in the person table if you only want one, or a junction table of personid and addressid with as many records as you want, you could then do a groupby and if they all match for a family then only one would show for your report you wish to send.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.