AnsweredAssumed Answered

Conditional view by Username How?

Question asked by ziceg on Apr 30, 2013
Latest reply on May 3, 2013 by Stephen Huston

I have a table A that has the following fields:

- Full Name

- Username

 

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.

 

Thanks

Outcomes