I'm not even sure how to ask this. Likely with the expertise in this list,
you all will understand what I'm trying to do.
The gentleman who created the system I work with (20+ years ago) set the data
up in multiple databases each in their own folder within the same tree
structure. Something like this:
ACCOUNTING
|___RECEIVABLE
|___PAYABLE
|___FIXEDASSETS
|___BILLING
|___GENERALLEDGER
|___PAYROLL
Etc.
Each of those subfolders has its own database, and 90% of what happens in
each folder stays in that folder.
However, I've run into a situation that requires me to share data between two
DBs. I'm pulling data from one DB and dumping it into a temporary table and
modifying it as I go. I'm at a point now where I need to pull data from
tables in a completely different DB in a different folder, and am not sure
how to do this.
If I drop the connection to my current DB to connect to the second one, I
cannot update the temporary table in the first DB. There must be a way to do
this that I'm just not aware of. Thank you in advance for the insights that
are forthcoming! ;-)
Damon J. Gray
Anvil Corporation Business Services
(360) 937-0770
