Allocate Get(AccountName) to a staff record
I've set my DB up with account names to allow levels of access and security. Once in the DB, there is a table for internal staff. Internal staff are named on projects.
What I'd really like to be able to do is for FM to detect, from the AccountName, who an internal member of staff is. From here, I can have a home screen for each member of staff giving them a heads up on their projects.
Is there any way to determine on login that Get(AccountName) = "Bob Smith" is the same as Staff Record "Robert Smith"?