Mark,

I suggest the following:

1 - use SPT cursors called from Back End stored procedures instead of VFP views - advantages:
* more control
* less net traffic
* faster server side processing
* no VFP database needed

2 - use local free tables for look-ups - updated from server as needed

This is the approach I took and it has worked extremely well

Ken