Hi Chuck,

The basic reason why I was using Remote Views (only to find out it's not 'fast enough') is that that's the way to go as far as 'Client/Server' is concerned right? I really thought accessing VFP tables via ODBC would have the processing relegated to the server. But how come the SQL Pass through (which is what Remote Views do right?) documentation I read explains it does the processing at the backend? It even offered a tip saying one may already detect the fetching to the workstation has started by checking the USED('viewname').

Does that mean I am better off putting method code put in the form interface of the user that will go something like this?:

USE Mastertable ORDER NOTTAKEN
SEEK( "N" )
... LOCK RECORD THEN REPLACE TAKEN WITH .T.
USE

The above would mean that the 100 or so users will be opening the same mastertable simultaneously. Would that be a problem as far as hogging network resources is concerned? Is that not 'file-sharing'? (as opposed to client/server)

I can't thank you enough with the valuable inputs (your time too) you have shared with me. Needless to say, it's very much appreciated.

Looking forward to your reply,
Dennis