If you define identical account names and passwords in both files, actions that open File B will open that file with the same account name and password as File A. (There are a few exceptions, manually opening the file by selecting Open from the File menu and scripted Import records steps will still trigger a request for a password.)
Thanks for your fast reply. I do get that if you have identical account names and password on both files, then it will work, but is there a way to do it without having to duplicate the information?
For example by scripting? I've been thinking but don't seem to come out with any solution....
What information do you want to duplicate?
The access privilege settings? That can't be scripted, but you can script a process of updating passwords and adding new accounts (to link to existing privilege sets) in the other files so that you don't have to run around and manually change things in each file everytime you need to either add or change a password.
You might also want to investigate setting up external server authentication on your server.
What I meant by "duplicate information" is the account name and privilege.
Now we use Windows AD network here but would you recommend writing a script to add/copy account and privilege information to all fiels or using an external server (ex: Windows Server) to authenticate?
I started looking into the external server solution but the challenge is we have a mix of mac and windows... but the good thing is that I don't have to restrict usage on the mac users since they are all managers and need full access.
I've just started learing more about external authentication myself. It looks like a very useful options for multifile hosted solutions provided you can stay on very good terms with any IT person that's responsible for maintaining this on the Domain for your server. (You don't want such a person changing settings for groups you need for FileMaker without checking with you first.)
You can't copy the details of a privilege set from one file to another. The settings are too specific to each file, but once you have defined each needed privilege set in each file, you can design your system so that you can enter an account name, password and privilege set name in some text fields and then a "control script" in your main file can call scripts in each secondary file, passing this info in a script parameter. Each of these sub scripts would then create the needed account name, password and privilege set in a secondary file.
It is very interesting. I am definitely going to take a look at creating a control script.
Thanks for your advice!