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