Then REMOTE view should help. Something like:

create data hi
create connection vfphello connstring (;
'Driver={MICROSOFT VISUAL FOXPRO DRIVER};'+;
'SourceDB=C:\Foxwork\Vfpapps\;'+;
'SourceType=DBF')

CREATE SQL VIEW hello REMOTE connection vfphello share aS;
SELECT *;
FROM RECLIST;
WHERE nIDnumber = 1234567

use hello && table is not open

>We choose the specific record based on a field name nIDnumber; the table is indexed on this field.
>
>This is what I tried:
>
>OPEN DATABASE DBNAMES
>
>CREATE SQL VIEW ViewOneRecord AS;
>SELECT *;
>FROM DBNAMES!RECLIST;
>WHERE nIDnumber = 1234567
>
>
>However, if I "DISPLAY STATUS", I find that the big table is open (as well as the database).
>
>CM