Get(Username) isn't updating when I log in as the Vendor instead of me.
Use Get (AccountName) instead. User name is the name specified in the application's preferences, so it depends on the computer being used, not the credentials provided at login.
Wow thanks! I'll test it shortly and let you know...but it SOUNDS right. Thanks!
The way filemaker sets this up confuses a lot of people. Username is text that you set in Preferences, but then filemaker automatically displays it as the Account Name when you log in to a password protected database. This is a "feature" I'd love to be able to disable on a few of my systems.