FN-FORUM: ODBC Query two DB's

date posted 3rd August 2005 10:32

Hi All, I am producing a report based on information coming from 2 DB's
both of which reside on the same MS SQL server. Having made the ODBC
conncetion I am quite happy pulling in the respective tables from one DB
want I now want to do is pull in the Tables/fields from the DB but this is
where I loosing the plot.

I am thinking along the lines that I need a VB command or some kind of
dual ODBC connection. Am I making this more comlicated than it really is?
I only have one common ID to match to and that is ProductId

Andrew