storing e-mail addresses in table

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

Hi may i know what is suppose to be done in this situation. I have a contact
database and now some friends have got more than one mail address can i store
them in a way that there's an option to select one of the mail addresses at a
time perhaps from a drop down list thank you
 
Hi may i know what is suppose to be done in this situation. I have a contact
database and now some friends have got more than one mail address can i store
them in a way that there's an option to select one of the mail addresses at a
time perhaps from a drop down list thank you
Click to expand...

Create one table for Contact, where you store information about the
person, and then another for EMail. Something like

Contact(
ContactID,
FirstName,
LastName,
...)

EMail(
EMailAddress,
ContactID (link to Contact)...)
 
Back
Top