Jorge,
In general, fetching all the records at once is actually faster because VFP wastes a lot of time bringing in the records 100 at a time (the default). If you want to have the fetch go on in the background while you're doing other things you can. Just make sure you don't have the views sharing a connection.
You can use the view's MaxRecords property to set the maximum number of records to fetch. You can also create a parameterized view by setting a filter condition and preceding the value with a ?. For example, if you only wanted records where MyField was equal to the variable m.lcMyVar, you could create a filter on MyField in the view designer by using MyField as the field and ?m.lcMyVar as the example.
>Thanks it worked great, any performance issues in doing this?, when implemented it will be on a LAN also, the dbf is the clients master table for a car dealer, right now it's about 2000 records long and under 1 megabyte, and I don't think it will grow too much too soon, so I don't think I'll have a problem in this particular case, but, is it possible to do it fetchin only a fixed amount of reocords if the need should rise?, thanx again