Report Based on User's Role
Hello, What is the best method to create a report based on a user's role? I created a table which contains a list of users, their ID, and their role. I tried to establish a table to table relationsh...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Set the Key field of the Users table to be the userid field.
Then on the details table where you have the report, make a relationship to the Users table and on the right side of ther relationship use a formula user field called
[Current user]
with a formula of User().
Now you can look up any values from the Users table down to the details table.