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

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
How to properly store e-mail addresses in Access table 1
Windows 10 operating system - using firefox browser - yahoo mail. 5
Human Relationships and Address 2
E-mail addresses mysteriously unresolved themselves... 6
E-Mail Addresses 0
A Bit Confused 1

Back
Top