You will need to script the password changing process for your users. You can use the various Account script steps to pass credentials as script parameters over to the second file and run updates to their accounts there.
There's a good module at modularfilemaker.org that has password / account management built in. You might want to take a look:
Thanks...was hoping there was an obvious solution. I'll review this! SG
Thanks again for the point in the right direction Mike. Was hoping there would be an easier process that I might have been missing...this is a pretty intensive work-around (for me) and may need to rethink my file and use of multiple files linked to each other vs a single larger file.
(or decision to create the un/passwords and plugging them in to each file in advance vs letting users create their own)
I can think of two other options:
2) Use external authentication (LDAP/Windows Active Directory/Apple Open Directory) on both files.
3) (This has some disadvantages, especially depending on your overall security concerns and protocols) Create a single account for each privilege set in the second file and duplicate that account in the primary file. Once the user has signed-in to your primary file, automatically (ie. in the Startup script) Re-Login with the single, shared account for the same privilege set (you can use Get ( CurrentPrivilegeSetName ) to determine the privilege set of the currently logged-in user.) Now they have access to the second file through the shared account, without specifically needing an account in that. Of course, any Get ( AccountName ) script steps used after the Re-Login would reflect the shared account, so you might want to save the AccountName in the Startup script before re-logging in (ideally in a field that is not modifiable by the shared account so that the user can't change their saved account name).
Lot's of pro's and con's I can see.
I usually set passwords only on the data file, since it's the data that needs security. The display file would likely have a limited-privilege account (with an auto-entered password) that would not allow editing layouts and such.