storing e-mail addresses in table

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
 
P

Piet Linden

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)...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One field, multiple e-mail addresses - mail merge? 12
Storing E-Mail Addresses in Access Tables 0
E-mail addresses mysteriously unresolved themselves... 6
How to send an e-mail to a person w/2 different e-mail addresses 5
importing e mail addresses from excel 1
E-Mail Addresses 0
Saving e-mail addresses 1
e mail addresses 4

Top