Automatically open/login to a shared DB
I have created a main solution that we are using now all the time in our business.
More recently I have created a secondary, separate database that relates to the main one.
For some context, the main DB holds all jobs, estimates, customer information and products details, et cetera. The new separate DB is used for manipulating the quantity of stock of those products.
My question is: when the user opens up the secondary DB and logs in, a message pops up saying the other DB is in use and could not be opened, and to open it in using the Open Remote command. If I do this it works fine, but I don't want the user to have to log in twice; is there a way around this, so they only need to log in once?