merging tables for 1 query

[toddbingham]

OK, have a good one here.

I have several link tables for different that represent different companies with our company. This is linked to live data. In each table, there are several feilds, Name, ID, check number, etc.
What I would like to do is merge these tables, delete all of the other feilds except Name, merge these into 1 column. Then i would like to insert it on a form so that they can search for an employee within the companies as a whole without having to search through each company for 1 employee.

How would I accomplish this?

Thanks.

 

[DomZ]

Well first is that you would need to select some Fields and then join them.. either using inner, left or right join...
For the rest then, you can use that query as a record source of a subform or form for instance

 

[toddbingham]

Dom, how would I do that?

 

[DomZ]

Give us more information

 

[toddbingham]

OK, I can design a new query, select which tables that I want to pick from, example, the table for each company, (1, 2, 3, 4, 5, & 6). From there I can select the field, "Employee_Name", from each company. How do I merge them into 1 column on the results of the query?

 

[DomZ]

oh then i dunno.. sry....
but maybe..:
INSERT tblCompany1.EmployeName, ... INTO [SOMETHING(it's usually a table.. but i dunno how to do it for a new field in the query]