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
Ken B. Matson
GCom2 Solutions