6 Replies Latest reply on Mar 29, 2013 1:12 PM by MarkHartley

    Flexible System for Storing Multiple Email Addresses, with Data About Those Addresses?

    MarkHartley

      Title

      Flexible System for Storing Multiple Email Addresses, with Data About Those Addresses?

      Post

           I'm creating a contacts database, and I'm not sure how to design it, given what I would like it to do....

           1. I would like it to be able to hold unlimited email addresses per person. Some people have 1 address, but some have 5, but I don't want to just create 10 email address fields, and fill them as necessary. That seems clunky to me. 

           2. I would like to be able to store data about those email addresses. For example, is the email address still valid? Is it a work or personal email address? 

           My initial instinct is to create a table just for "Email Addresses" and then have an entry for each one, and link them to the record for the people that have them. 

           But, that seems a bit awkward also. 

           Is there a more smooth way to do this?

           Or is a separate table for the email addresses the best way?

           Thanks very much for any guidance you can provide. 

           markus