I have a table of users, each with a __pkUserID field that corresponds to their Account Name that I created in the File > Manage > Security pane. Each user also has an __fkTeamID. When a user creates a new record I would like to set the __fkTeamID to the same __fkTeamID as the currently logged in user.
Said another way, I need to get the currently logged in user's account name and match it to a user in my user's table. Then I want to get that user's associated Team ID.
What's the best way to accomplish this?