I am developing a networked app in VFP 5.0a. As I have been designing my databases, I've been operating on the assumption that while my tables will all reside on the machine acting as file server, the local views for data entry will all actually reside on the client machines. For this reason I have created a database called LOCALVIEWS that contains (you guessed it) nothing but views. When the network is set up, each client will get this LOCALVIEW database, and I will point the app to the file server.
My question is: is this the best way to do this (or the worst)? Should the views also reside on the server? Are there any performance implications of one over the other?
Thanks.