Link Columns in two tables

[robman25]

I have two tables that i just imported from Excel, Company and Client.



The Company table has information about various companies. The Client table has all of our client contact information.

I would like to have a "Company Name" column in each of the tables. I want both of those columns to link together. Is that possible?

If so, please help by giving detailed instructions, or post a link to a page that will show how to do this.

Thanks in advance!

[Robeen]

Does either table have a CompanyName field right now?

You can right-click each Table and select Design & then add the fields to the Table.

Next - you click on Database Tools and select Relationships.
In there you add your two tables and create a relationship between the newly-created CompanyName fields in the two Tables.

Google 'MS Access 2010 relationships' - there's plenty of info out there and good help/instructions.

All the best!

[robman25]

Thank you, that is just what I was looking for!

[Robeen]

Happy to help!