linking contacts

[jkorinek]

I am udating a database in access that was given to me with information already on it. There are two tables. One table is for company names and another table is for HR contacts.

I want to connect the contacts table to the company names table by company. For example, I want to go to the company name table, click on wal-mart's side bar and have the HR contacts for that company show up.

Company name is included in the HR contact table.

[TheShabz]

you will need a Form and a query.
1. make a form
2. make combobox that has the company names from the contacts table.
3. make a select query joining the two tables on company name and set your Criteria for Company name to Forms!myForm!myCombo where myForm is the name of the form and myCombo is the name of the combobox you created.
4. make a subform on your form using the wizard and the query you created.
5. Add a Me.Requery in the AfterUpdate event in the properties box for the combobox.