>>>>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.