Query multiple tables

[steve1111]

I have a few different tables that hold somewhat like info. A tblClinics has ClinicName address, city, state, zip, a tblPatient, LastName, First, all the address fields, tblDrivers, LastName, FirstName all the address fields. What i am hoping for is to have a txtbox that can search all the field in those tables and pull the names and addresses in. so if i have a clinic at 123 Main st in New York and a patient at 123 Main in Denver, entering 123 Main would pull the records from both tables in some sort of query. Or type a lastname and get all the patients named Browns addresses or a Brownsburg clinic name.

I am sorry if this has been posted before, i am having a hard time labeling what to call it. Also, i have a little VBA experience but just starting out.

thanks

 

[jdraw]

Show us your relationships window. Extend all tables so all fields a re visible.
Readers have to understand what you're trying to do; have some familiarity of your data; and your database structure before offering focused responses.

 

[MarkK]

If you are treating addresses distinctly, and multiple types of other objects might have addresses, then you should have an address table.

 

[steve1111]

Thanks MarkK, i think i know what you are getting at. this is a third party db i have a read only ODBC connection to. would there be a way to "make" my own table that combines all three of the tables i am connected to?

 

[steve1111]

Jdraw, there are no relationships between the three tables, the are all independent.

 

[MarkK]

Then you need a UNION query.

 

[jdraw]

You could see if the info here could help.

 

[steve1111]

Thank you both for the help, after reading up a little more on Union queries, it worked perfectly, exactly what i was looking for.