We have two sites that are some 10 miles apart, and these sites are connected via a T1 line. The server resides at one of the sites. On the server, there is a table called patient.dbf that has over 2 million records in it, with about 50 fields per record. A user only needs to see one record at a time.

When the table is opened with the USE command at the same site as the server resides at (ie does not send data across the T1), the table opens instantly. When it is opened with USE at the site remote from the actual server machine, it opens painfully slowly.

If we use a SELECT-SQL command to select just one record from the table at either site, the entire table seems to be opened in the current work area in order to execute the selection. That's not a problem at the 'local' site, but again, creates an incredible drag when executed at the remote site.

How does one 'select' just one record from a very large table without actually causing VFP to open the entire table in its own workspace?

C