Emmitt and Adriana,
Thanks to both of you. I will look into the SCONNECT as you suggest. - damon _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Adriana Montano Sent: Monday, November 24, 2008 3:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: query two databases Damon, Look up SCONNECT / SDISCONNECT and SATTACH/ SDETACH in the Help Files. You can stay connected to your first database and access tables/data from the other databases. -Adriana _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gray, Damon Sent: Monday, November 24, 2008 4:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - query two databases 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
