Samuel,

You need to use a parameterized remote view to retrieve just a single record or subset of records. There's an example of how you setup a p-view over on my website. It's a local one but the concept is the exact same.

>I create an index of a table in SQL server.
>can I call this index to use in my VFP program?
>and can I use the "Seek" command to search records?
>If so, how to do this when I CREATE SQL VIEW?
>I have tried to index a remote view, but I found
>all records will return from SQL server to
>my workstation. This will increase the network
>traffic that I don't want.
>The property "Fetch" how many records at a time
>is useful, but the view only allow me to
>"Locate" a record. How to "Seek" a record ?
>Becuase I found this is the fastest.