>If the same application can be set up to run using test data or live data, where is the best place to change the table paths for the form dataenvironment? Also, is there somewhere on the UT that has sample code for doing this?

I have an entry in the CONFIG.FPW that does this. It can be one of three entries:

PRODUCTION
TEST
DEVELOP

If the entry isn't found, Develop is assumed. I have a property in my application object that holds the name of the DBC. I then OPEN the DBC and SET DATABASE TO the Dbc. After that, I don't have any problems. The data always goes to the correct location.