COMPANY RECORDS WITH MULTIPLE CONTACTS

[JOE POLLOCK]

I have an Access table which contains company contact information for the
companies in our db. There are multiple listings for each company. I would
like to be able to open a form with the company contact information and a
subform which would list each person that we have with that company and their
own information including phone and email. How can I do this?

 

[Al Campagna]

Joe,
A tblCompanies with each company having a unique key field
CompanyID... should be the basis for your main form (ex. frmCompanies).
That table might contain CompanyName, Address, Terms, etc...
That's the ONE part of the data/realtionship

A tblContacts, related to tblCompanies by a CompanyID would be the basis
for a continuous subform (ex. frmContacts) on the frmCompanies form.
That table would have fields like ContactName, FaxNo, TelNo, EMail, etc...
That's the MANY part of the data/relationship

The subform is related to the main form by the Parent CompanyID to the
Child CompanyID.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."