I have several databases hosted on FM Cloud using FMP 15:
Main Database - houses all customer information
6 Supporting databases - house supporting information that only updates the main database when a button is pressed and a script activated running PSoS
When running a report of some customers on the main database I can view the information on a summary page, but when I go to export the information I am prompted for the username and passwords of the 6 supporting databases.
All the databases are encrypted on FM Cloud (I was forced to do that) and the passwords saved to keychain.
Any ideas on how I can get this to stop asking for the passwords of the 6 supporting databases?