Multiple Table Query

[Guest]

I run a database that keeps various sorts of records, one Common field
between them all is the 'Parish' field.
What I need is to run some type of query between all of the tables with this
field so that I can see what information of every type we have for this
'Parish'. Rather than opening each table in the same database, I need a query
that will display the record number for each entry it displays, to keep it as
simple as possible to run.
I have tried it a number of ways but so far had no luck and need to have it
running as soon as possible.
Any help would be brilliant.

 

[David Cox]

Could you give us an example of the sort of output that you want to see?

 

[DANIEL BLOOMFIELD]

A question I have... Do all the tables have the exact same number of
parishes or are all the names of "Parishes" in every table? If not, you
will not pull all the information from each table. My recommendation would
be to create a master table with all the parish names and use that to link
all the other tables, which would guarantee that all records from all tables
are queried correctly.