Howard:
You can set some kind of path as the app starts up in the MainProg.prg
We allow our users to select data directories and store in a property on a form. The next statement gets the directory into the path while the app is running.

set path to alltrim(set('PATH')) + ', ' + (this.DataDirectory)

We are using free tables that were referenced above, but we store our views to those tables in a dbc that is located in a sub-directory called "data" that is under the directory where the EXE is located.

* We can't find our DBCs without this next statement.
set path to fullpath("") + "data"

We also have lots of Crystal Reports that are located in a "reports" sub-directory, that is put into the path as follows:
set path to alltrim(set('PATH')) + ', ' + fullpath("") + "data"

HTH
Mike