I have a front end file which the user logs in to. I have a simple text box which displays the name of the user (Welcome g:AccountName which when user the user sees it they see Welcome Jane if Jane logs in) who logs in and that works fine. It uses a global AccountName field.
I now need to display the department name too. Say John works in Sales, Jane in Accounts and Joe in Engineering. When Jane logs in I need it to show 'Welcome Jane - Engineering'.
I have a table in the back end file with all users in there but I need it to look at the name of the logged in user and extract Name and Department. I can get one or the other, any ideas?
FM Pro Adv 15
Mac High Sierra