Just a quick basic intro:

CLOSE ALL
OPEN DATABASE Connect1
SET DATABASE TO Connect1
MODIFY DATABASE

Now add a new remote view, and select Connect1 from the Connection list when prompted. You should then get a list of all available tables. Select a table. In the view designer, on the Fields tab, select the fields to retrieve INCLUDING PK field[s]. Click on the Update Criteria tab and check the field[s] that make up your Primary Key. The fields you want data updated for should have the Update column checked. Check the box that says Send SQL Updates.

On the menu pad that says Query, click Advanced Options, check the Share Connection box, and make sure both "All" boxes are checked. you can also set these defaults under Tools.Options/Remote Data but it does not always carry over to the View Designer [at least not for me].

You can add more tables to the view as long as you join them. You can do this visually by dragging a common field from the parent table and dropping it on the child table.

Save your view. You can now USE this view like a table.

>I have been using VFP successfully for years, but am now trying to learn about using ODBC/CONNECTIONS so that I can create more efficient client server systems. I know this is elementary for most of you, but it is my first exposure to it so please understand.
>
>I have my database (MASTER) set up on the server.
>I create a new database on my workstation (CONNECT1). This database has a connection (also called CONNECT1). I set it up using a connection string:
>
>Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;PWD=;SourceDB=n:\appl1\master.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
>
>Now when I set up this connection, I specified the database name (MASTER) and also the path (N:\APPL1). In my way of thinking, when I open the database CONNECT1, that should give me access to that connection and therefore access to the tables in database MASTER. But that doesn't seem to be happening. I'm missing something but I don't know what.
>
>Can someone walk me through this process so that I can set up my remote views?
>
>Thanks!
>
>Fred