Hi,
I don't think this is possible for Local Views (someone may contradict me here). You might think instead about limiting the user's search abilities. If he's entering a name or classification insist that he enter at least 3 (your choice of length, of course) characters. I've done this for a remote view where they could return as many as 30,000 records. If they don't enter 3 or more characters (cuts to result to about 1000 max) they have to confirm they're willing to wait for the results.

In other words, rethink what you are allowing your users. They may not need the full list.

HTH
Barbara

>Hi,
> How could I implement the feature of Fetch As Needed for remotr view but not available for local view for my application?
> I have a member table that contain 5,000 records at this moment. It is just the beginning. The member could be calssified into many classification. Each classification allow 10,000 number of members.
> I would like ot display them in grid and let user to seach it using incremental search. So that, I only display the members records for one classification at the same time. However, since the number of members for each class could up to 10,000 records. How could I fetch them as needed. E.g. 500 per time, and append next 500 if required and etc.
> I SELECT the records into a temporary cursor recently instead of bind the native table into rowsource.
> My question: How to append records into cursor using fecth as needed methodoloy? USING APPEND FROM ?
>
>Thank you