I have a table A that has the following fields:
- Full Name
The Full Name field is used to create a value list, which used in another table B.
What I would like to do is when the user logs in, get the information of what username was used to log in to then determine what records of Table B they can see.
How do I get it to:
a) get the username from log in. I'm assuming it's just to create a script and use the "Get (Username)" and put that info into a Variable to then use later (would this be a $User or $$User type of variable)
b) know that if username "auser" = to "Anthony User" as per Table A
c) set a script so that only the Records in Table B that in User field equal to the above are shown.