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
Mark,
Thank you! On the Users table, I made the UserID field the key field. I followed your instructions to create Current User field. However, the User() is only returning my name back. I've included screenshots below.
- MarkShnier__You
Qrew Legend
The Key field of the Users table should be a field of type User. There will not be a formula user or List User field on that table.
The field on the details table should be field type Formula User with a formula of User()
That is the field you will use in the relationship back to the Users Table.
