Get(UserName) will return "Bob". Get(AccountName) will return the Account used to log in. If you have your file set to have it los in using an account, then all users will get the same thing. Check under File Options.
One of those (B) fields is a "Auto-enter Calculation", which check this condition: "If (Field1 = "Yes" and Field2 ≠ ""; Get(AccountName))"
Change it to a Calculation field, and set Storage Options to "Do not store…".
I tried what you adviced me to do...and it didn't work better.
I then thought that I, maybe, should manage "Accounts and Privileges" in the (B) database:
once I added people to it (it was blank, except a default "Admin" account) it worked correctly, even without changing the field to a "calculation" one.
So, was that an error from me? are you "obliged" to add all accounts in the sister (B) database too? Because everything was working fine before this, except that Get UnserName problem!!!
Thanks very much!!
are you "obliged" to add all accounts in the sister (B) database too?
Yes - if you want to protect it. If it's set for automatic login, then anyone can open it directly and do whatever they want.
Or you could consolidate the two tables into the same file and save yourself the trouble of maintaining duplicate accounts and privileges.
Thanks for your help, comment, I did as you suggested and consolidate the database...it now works like a charm.
So, to stay in the topice, the solution was either to set account and privilege for each users..or consolidate the 2 files in 1