Larry,
Yhank you for the explanation and I follow it now. I was assuming that what was 'displayed' was actually stored in the scx file.

Regards and thanks again for all your help.

Gerard




>>>>>if your database in a directory directly under the main directory called Data, the value stored in the SCX file is
>>.\Data\MyDatabase.Dbc<<<<<
>>
>>Larry, If you can bear with me but I still dont follow this. The \data\ bit.. is this interprted as a 'Relative' directory, I guess it must be because when I copy the APP out to the client, whose folder is f:\client, it looks in f:\client for the DBC, not in \Data. (The only palce I would set this would be in the Disktop 'Start in Properties').
>>
>
>Gerard,
>You don't set this. When you add a table that is part of a database to the DE, information for that object is stored in a record in the SCX table. The information is stored in a memo field called Properties. The line in the memo field pertaining to the Database property actualy shows the path relative to the directory where the form is located when the table was added.
>
>For example, say you had a project with the following directory structure:

>Main Directory
>    Data
>    Reports
>    Forms
>    Prgs

>
>With this structure, you do all your development from the main directory and configure a path to the subdirectories so VFP can find the various items when you modify them.
>
>Now when you create a form in Forms and add a table that is located in Data, the memo field line shows this when you open the SCX:
>
>Database = ..\data\MyDatabase.dbc
>
>Starting from Forms, the .. signifies that VFP should look one level up the directory hierarchy and then in the Data subdirectory for MyDatabase.Dbc. When you modify the form in the Form designer and look at the properties of the Cursor in the DE, you see the path where it exists on the hard drive/network drive. In my case, it displays:
>
>C:\Dev\Projects\VFP\Data\MyDatabase.Dbc
>
>VFP interprets the relative path and displays the "real" path. When you copy the same directory structure to a new drive or a new PC, the relative path doesn't change but the interpreted path will.