Master Name Index

[recon0302]

I have a relational db with several tables in it. Each of these tables contains controls for people's names. I need to build a master name index that returns the results of all names in the tables based on a search. I tried to do this in a query but only the tables that are linked come back. I tried relationships but that didn't work. How can I query across several tables to get the results. Or how can I build the query to do what I need? Help!

Marty

 

[Jon K]

Use a Union Query to pull the names from the tables, e.g.

Select [NameField] from [TableA]
UNION
Select [NameField] from [TableB]
UNION
Select [NameField] from [TableC]
... etc.