I apologize if this has been asked and answered - I have had no luck finding it.
I am only into my second month learning FM and so far like it. However, I have ran into a bit of a snag when it comes to getting two FM DBs to talk with each other. Some background;
DB1 has a particular function that will be used by multiple client systems in the future. Each client system will be set up with a UID and Pass to access just their data.
DB2 is the client system. This database is managed by end users who will create UIDs and Passwords for their employees. Each client system needs to have access to that client's info on DB1.
What I am finding is that FM uses DB2's UID to access DB1 similar to Single Sign On. I need it to use a stored UID and Pass stored in system variables. Any Ideas?