Multiple Records into Single Record

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hi All -
I'm in desperate need of some help/direction on this challenge I've
been faced with. I have an excel file that I'm converting over to
Access so I can use it for a marketing campaign this weekend. The
database is basically a list of customer contacts that I need to have
updated online. The database is listed with the following columns:

Account Number, Company Name, Contact Name, Email, Phone, etc;

If the company only has one contact then it's no problem.
Unfortunately most of the companies have 2-4 contacts which means I
have 2-4 records for the same company. What I need to do is take those
additional contacts and merge them into one record with more columns.

Account Number, Company name, Contact 1, Email 1, Phone 1, Contact 2,
Email 2, Phone 2, Contact 3, ....

Can this be done?

Thanks in advance for your help.

-Jake
 
Sounds like you should have a Company table with table information and a
Contact table with the mutiple Contact information. You will need to create a
relationship between the two tables.

ex.

Company
-----------
CompanyID (primary key)
AccountNumber
CompanyName

Contacts
-----------
ContactID (primary key)
ContactName
Telephone
Email
CompanyID
 
Thanks for the quick reply Peter & Carrie. I understand that I really
need two tables with a one to many relationship to do this properly.
However, due to my web application and the way it was designed I need
to have all of this contact information in one record. If my deadline
for this project wasn't so soon then I could possibly look at changing
the web app but unfortunately I don't have much time.

That being said, am I stuck going record by record and moving the data
manually to make this work?

Thanks again for your help!
-Jake
 
Back
Top