Doug,
There are pretty much two options. You can pull down smaller amounts of data from the server using either parameterized views or SQL pass-through. This is the typical client/server model. You ask the user to narrow down your search before you query the server. Your other option is to just create the indexes on the fly. VFP indexing is quite fast and you might find that the performance is acceptable depending on how many records you're talking about.
>I am just upsized an application to use SQL Server 7 and am using remote views on the data. Previously I was using compound indexes on local tables, what is the best way to replace this functionality on a remote view? I don't want to create indexes on the fly due to the large amount of data involved? Any ideas?
>
>Thanks,
>Doug