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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
One field, multiple e-mail addresses - mail merge? 6
Recover Outlook Express data 1
Human Relationships and Address 2
E-mail addresses mysteriously unresolved themselves... 6
Journal 'Automatically record these items' is blank 0
Interested in thoughts on keeping the integrity of historical data 17
Hiding recipient addresses when sending to lot of recipients usingOutlook 2010 4

Top