How do I use an SQL table from Foxpro???

I am able to connect and setup a View, but I have to build a select statement that narrows down to one (or a few) records in the SQL table. If I just try to "open" the SQL table, it will download *ALL* of the table and can take MANY MANY minutes. SO my view just gets the ONE record I want, but to go to another record, I must close the view, change the select statement memory variables and open the table again. It is literally 100 times faster to use Foxpro on a copy of the SQL table, but I need to use teh real SQL data.

HOW DO I OPEN A SQL TABLE????

I do appreciate your help!!!!!
Joel
Houston, TX