>
>I put Do finance_report.prg in a menu option for the application to split it out. If I run it before opening any forms, it does great, but the form won't come up because the file is already in use. If I get out and run the form first, it comes up like a champ, but then the report won't run because either the table can't be found, is already in use, etc.
>

First thing I might try is renaming the table 'Itenerary Details' to 'IteneraryDetails', removing the space...

Even though VFP lets you do this, I don't think it's a good idea because much of SQL syntax looks at spaces to determine alias.

If I had to guess at what is happening, I would guess that the view that is based on the two previous views is crashing, because the SQL engine is treating the space in the table name as a table and its alias. Since both underlying tables are using this same syntax, the SQL statement is trying to open two tables with the same alias, and it's getting confused as hell.

Alternatively, you could redefine the 3rd view to not use the first two, but build the SQL entirely from scratch.

Also, unless you'll need to update this cursor (I don't think it's possible anyway), you don't really need to make this a view, you could just select into a cursor.