Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Fri, 15 Aug 2008 09:30:02 -0700,    group: microsoft.public.access.tablesdbdesign        back       


storing e-mail addresses in table   
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
date: Fri, 15 Aug 2008 09:30:02 -0700   author:   Amin

Re: storing e-mail addresses in table   
On Aug 15, 11:30 am, Amin  wrote:
> 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

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)...)
date: Fri, 15 Aug 2008 09:35:57 -0700 (PDT)   author:   Piet Linden

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us