Get(accountname) does not work
Operating system version
Description of the issue
I want to control access to different parts of my database by requiring the user to enter their account name and password.
Irrespective of the account name used to login it returns "admin".
Steps to reproduce the problem
I have used included the account names in a table of users and created a field containing the formula Get(accountname) in each related table.
My account names are Admin, User, [Guest] where Admin corresponds to access level "admin" with full access to develop the database, User can add, edit and delete records, and [Guest] is read-only. While the database opens with the required access level Get(accountname) always returns the name "admin".
Log into Filemaker as User (with the password) or [Guest] (with no password). I expect Get(Accountname) to return the account name entered at log in: User, or [Guest].
Log into Filemaker as User (with the password) or [Guest] (with no password). Get(Accountname) returns: admin