>>>>>Note: If the table is in a different database that the table, then it doesn't matter where the table's DBC is, as long as it is open.
>>>>
>>>>What do I have to do with my app though? Do I have to explicitly open the other database? Just adding the table to the DE doesn't
>>>>do it.
>>>
>>>Sorry, I made a typo - it should have been
>>>" If the table is in a different database than the *view* "
>>>
>>>Adding the table to the DE *will* open its database. It doesn't have to be the current database, it just has to be open.
>>
>>That's my problem. The table is in the dbc but the app always makes me browse for the dbc as if it doesn't know
>>where it is. The table in the DE has the correct path when viewed with properties.
>
>What is the DBGETPROP("myview","View","SQL")?
>Does the view's FROM clause have FROM database!table?
>It should have.

As generated from the view designer:

SELECT Process.*, Machine.machdesc FROM process!process INNER JOIN maint!machine
ON Process.machnum = Machine.machnum WHERE Process.partno LIKE ?vparampn

Database maint holds table machine which is giving the trouble.