I have a new scenario where I need to have ready access to one database from another. It's easy enough to use the shell command to launch the other database, but the problem is that if you keep clicking the button the launch the other database, you'll get multiple copies running at once. I've attached a pair of sample databases that demonstrate this.
What needs to happen on clicking the button is:
* Check for existing instances of the app to launch
* If it exists, bring it to the front
* If it doesn't, launch it.
I've got a rough idea of how windows are referred to using the API commands, which I've setup in the example databases, but when I haven't yet been able to put together a stable and consistent method of doing what I need to do.
Can anybody please help to make this work?
Thanks in advance!