Contact List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a list for more than one contact for a customer, how do I do
this.
 
Access is a relational database environment. You would create a table of
contact info (address, phone, etc.) and relate it to another table that
contains the person's ID and name.

tblCustomer
CustID primary key
LastName
etc.

tblContacts
ContactID primary key
CustID foreign key (realted to tblCustomer)
ContactInfo.......

-Ed
 
You must log in or register to reply here.

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

Best solution to merge multiple Outlook contacts easily 2
Access Sorting and grouping using multiple tables 0
Dell Optiplex graphics driver failure 2
Amazon Login Location Different 4
How to create a bubble chart with more than 2 variables 0
Ms outlook export. 0
Having trouble getting my current Outlook Contacts 7
Resolving Names in Outlook Distribution Lists 0

Back
Top