**********
>Hi Jill.
>
>> I had a view, w/the same name, in each DB - that used definition tables from LoanDB.
>
>That seems like it should work fine to me.
>
>>It seemed to work (Stonefield didn't like it, though).
>
>Likely SDT didn't like it because the DBC containing the source tables wasn't open. If you open both databases, then bring up the Database Explorer, it should work (of course, this is just speculation on my part <g>, so let me know if it still causes problems).
>
>Doug
**********

I use 4 databases (DBCs). 2 may vary depending on the specific company that is open for use. Some views use tables from more than one database and sdt works for me for everything I have tried. I don't make any special effort to open the databases. I always have the path set to the location of the 4 databases for the specific company. The tables for each DBC are in the same directory as the DBC. As far as I know, anytime you USE a table, the DBC is automatically opened if it isn't already. I think the key is to have the path set so your program can find the tables referenced in the view.