If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
COMPANY RECORDS WITH MULTIPLE CONTACTS
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? -- JOE |
#2
|
|||
|
|||
COMPANY RECORDS WITH MULTIPLE CONTACTS
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." "JOE POLLOCK" wrote in message ... 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? -- JOE |
Thread Tools | |
Display Modes | |
|
|