AnsweredAssumed Answered

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

Question asked by MarkHartley on Mar 29, 2013
Latest reply on Mar 29, 2013 by 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

Outcomes