Should be simple: how to move data between DB's with script?

 

DB #1 is large, keeps track of several things, including when we need to write checks to other people. DB #2 is the checkbook, a simple flat DB. DB #1 tells us when to write checks, how much, etc. It knows everything. Then we manually key in that data to DB#2, and it prints the checks. 

 

I should be able to make a script that will take the data from DB#1, jump to DB#2, enter that data, and print the check. Can someone give me some general guidance as to how to approach this? Could I import DB#2 into DB#1 without the two being related?

 

Maybe there's a better method in general to do that?

 

 Thank you.

Could I import DB#2 into DB#1 without the two being related?

 

Yes. I think you mean the other way round, though (it's best to use meaningful names instead of abstract ones).  So if your "main" file is open and you have established a found set of transactions that need to be paid by checks, you can then open the "checkbook" file and import that found set into it.

 

That said, why can't you print the checks directly from the "main" file? It seems like unnecessary duplication of data.