I want to display pivot tables using some information from one mdb dabase,
and some info from another mdb database; but they are linked by a common
factor (number) and if you look at the information in access, you canb see
how they tie into one another. it is a one to many relationship in the access
database.

is there any way i can use as decribed above?

thanks

Jack