Colin,
I have queried an SQL Server using ODBC and created a local table with the results. This was accomplished using the functions DBExec() & DBSetOpt(). What I would like to do is base a new SQL Server query on a field in the local table. Essentially what I need to do is to link a remote table with a local table either with a join or where clause, but I havn't be able to do it. Any help would be greatly appreciated.
Thanks,
capt52