merge data

[nana]

i used link functions to all my table coz i have 20 tables
which is used same field. the problem is i want to view
all data from all database and generate reports..

 

[JohnFol]

I think you need to look at UNION queries. . .

 

[John Vinson]

i used link functions to all my table coz i have 20 tables
which is used same field. the problem is i want to view
all data from all database and generate reports..

How are these tables structured? How are they related - one to one?
Why so many tables? What is a "link *function*" - that's not a term
I've ever used in Access?

More details please.