one thing and a big question ! I am building a school management system. Problem in french schools is that computers are old and LAN slow. VFP is able to work with more than one Database. So I have a 'common database' on the server and a local database on each station. The local database helds (contains ?) all lookup tables AND view definitions. I update the local tables in the same procedure than the reindex one. So in one 'shot' (few seconds) I do both things. All local tables have a 'mother' on the server. It works great .
My question is : when I update a lookup table, I update the mother table on the server (and the all station must launch the reindex procedure). Can I write an update procedure on a special VFP app on the server ? in other words, we always access datas on the server from the local stations, can we acces the local datas (one at a time) from the server ?. Am I clear ? The Foxil _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

