>No, I did NOT want to bring the entire datbase into a browse, but I did NOT want to have to open and close the database evertime I want to move to a new record (which I what I am doing now).
>
>I just want to be able to open the SQL database (view) and then be able to move the record pointer as I need. As it is now, when I try to OPEN the sql database, it tries to bring ALL records to the work station.
>
>I do appreciate any suggestions!!!!!!
>
>THANKS

That's the way a remote view works... basically it is sending a SQL statment to the server like...

SELECT * FROM YourTable

You can't access remote tables like you can local tables. What you want to do is limit your result set... or, just pull a 'proxy' view of the table for a pick list.

You proxy view will only bring the record ID and any fields need to identify that record to the user... like, FirstName, LAstName if it is a customer database.

Once you user picks a record, you can go get that full record with a parameterized view...

SELECT * from YourTable where YourTable.ID = ?vp_IDFromProxy...

You may also want to limit your proxy view in some way to... Lets say you have a pick list form with 26 buttons on it labled A-Z... When the button is pressed put it's caption into the View Paramater of your proxy view to get the records...

SELECT ID,FirstName,LastName FROM YourTable WHERE YourTable.LastNAme LIKE ?vp_StartLetter

*********
Remember, the rules of Client server BRING THE ABSOLUTE LEAST amount of data across that you can.

BOb