Thanks Ken

We may or may not actually upsize the app to SQL Server so we are only making sure that the upsizing process will be as easy as possible when that time comes.

As a first step we are making sure we do as much through views as possible.

Your point about keeping look up tables local but updated from server when needed is well taken and I would be doing that if it wasn't for the fact that the system is likely to end up being run on Citrix Terminal Server (I am not sure if the apps will be able to see local hard drives).

However what about tables such as the table that keeps all the surrogate key counters? Surely that table must be kept with the application on the server.



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