We are putting a Fox 6 front end on SQL 7.
We would like to do incremental searches on wide tables. To do so we create a 2 field remote view from the table. Is there a way to do an optimized incremental search on the view?

Obviously, in Fox, we index on a field and SEEK() on that field.
Views are different, I assume? Any hints?