About accounts, privilege sets, and extended privileges
You use , and to protect FileMaker Pro database files.
Using Custom Extended Privileges
I wouldn't ask for the department as part of the log in.
I'd use a table of account names with a department field in each record that records that account's deparment name.
Then you can do a standard filemaker log in, but a script can use get ( AccountName ) to look up the user's department name and pull up the correct layout for that user.
Thanks for that. I had thought about a username/password only which would fit with your model Phil but unfortunately in the company there are three people who have the same names in different departments. Hence, John West in Accounts and John West in Engineering.
I need to diferentiate between both users as obviously the information viewed will be hugely different. I like the GET(AccountName) approach as thatt would simplify things using the existing login screen, but taht wouldn't allow the use of the dept, unless I'm mistaken
They may have the same name, but they cannot/should not be given the same ACCOUNT names in manage security.
True, if names are tempered in such a way as to allow access but not to offer a clue to their namesake in another department that should work.