Pulling data from one fm database to another
I have two databases, one database requires user accounts to access, the other doesn't and anyone can use it. However the open database needs to pull data from the user account database for a drop down menu. Every time you you click on the drop down and asks to login. I'm sure there is a way to get around this with having the open database auto login with credentials but I lack the knowledge to find my way there.
Both databases sit inside FM server 12.
If anyone can help that would be great.