Hi,

Using VB6, is there any way to do a SQL or retrieve data
from two dbf file from different location using ADO to
form a single recordset which I intend it for use with
Crystal Report 8.5.

I had tried to use CR query designer, but it can't
using ODBC Visual Foxpro driver.

Is there any recommend way or refer way to do similar stuff
as I want only my Crystal report (.rpt) to pull the
required record automatically, without having to have individual
form for each report.

Please kindly advise.