The easiest way to do this is to combine your two databases into a single database with two tables. Then "the" database is already open and you GTRR will work as you envision. You can choose a layout based on the Invoice table, and even open it in a new window if you want.
Is this a viable option for you?
I suppose It would, but I really want to keep them as separate databases as I feel its more secure than having everything in one place. If the one database gets corrupted then I have lost everything.
If the one database gets corrupted then I have lost everything.
If the one database gets corrupted then ... I use the backup!
Immediately after your GTRR, you can use Select Window to specify the window of the other file so that it pops to the front.
Many thanks Phil, it worked !!