Join?

[burrelly]

I have a teple with the following fields:

Company
Contact
Email Address
Phone

Some companies within that list are unique while others are duplicated if I have more than one contact from that particular company.

I have a second table with the following:

Company
Industry

The companies within this list are all unique what I want is to add another field to the first table called industry and join the two tables.

Some of the companies in table one are not in table two and vice versa.

What is the easiest way to do this?

 

[DCrake]

What you first need to do is to add another table called contacts this will hold all the contacts from each of the companies. This way you only need the company in the forst table once.

 

[burrelly]

Sorry I would rather keep it as is. It is purely in access for the purpose of the join.