I am in the process of developing an access database for contact management. I have two table: Companies & Contacts, & a form for Contacts data entry. The relationship between these two tables will be based the company name. Each company may have multiple people working for it. In the form I have a combo box that links to the "Companies" table. I look up what company they work for and select it. What I want to do with the database is run a report listing each company and what contacts work for it.
The problem I'm having is setting up the relationship between the two tables. Do I use the CompanyID to link to the Company in the Contacts table? When I did this the report had an error. Do I use a query to so this? Tired adding the CompanyID to the Contacts table and use a dlookup to populate it when I find the company name but it isn't working.
I've tried running a report but it doesn't group the company with its contacts.
Thoughts?