I’m late to the world of Secret Windows as I’ve typically found issues with them but as I’m trying again to make use of them, I have a question or two.
Using the feature of Auxiliary files, I have other secondary db files opening with no windows. When I close the primary db though, they obviously remain open in memory. How is a user to be aware that there are dbs open that are not seen nor are in the Windows menu? What is the proper way to manage this detritus?
When I open the primary db and then secondary dbs open before the .initialization procedure of the primary db is run, I am left with many lookups on the primary not displaying their values that were dependent on the seondary dbs being open. I thought perhaps a ‘DesignMode DataMode’ procedure might be the appropriate way to ‘update’ the primary db but that would have happened in the .initializtion procedure. How would that best be handled.
In the old ways, I’d just open the secondary files first so that the primary file being opened last would automatically have the secondary files open and the lookups would automatically take care of themselves.