=?Utf-8?B?T3JuYQ==?= wrote in
:
Setting the forms' recordsource sound even better, I'll try that.
BTW, when I tried to join the two tables from the two different
databases I got an error, so I found a workaround.
is the following syntax possible at all?
SELECT field1,field2 from table1 in 'PATH1',table2 in 'PATH2'
WHERE table1.field1=table2.field2
That's an implicit join, instead of the explicit join, and yes, it's
fine, as Jet optimizes them exactly the same. That is, it will be
just as efficient as a join in utilizing indexes if it can (which it
probably can't in this case with heterogeneous data sources).
--
David W. Fenton
http://www.dfenton.com/
usenet at dfenton dot com
http://www.dfenton.com/DFA/