1 Application is score by 10 reviewers (users) in Scoring Table. (1 Application table has many Scores)

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
One application is score by 10 reviewers (users) in the Scoring Table. Need to show the Reviewer information on to the scoring table. But a reviewer can only see own information. Other reviewers should not know who are the others reviewers to that application. When I create 10 users fields in the Application Table and then do the lookup on to the Scoring Table, then all the reviewers know others reviewers. When I create one User-List than also lookup shows all the reviewers. 
What is the best way to handle this? 
Photo of A Grobe

A Grobe

  • 90 Points 75 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
On the reviewers table, I would create one field for Reviewer (user type) (not 10.) Besides this you can have the other fields for scores, comments et all. Then set custom permissions on the reviewers table for all roles (other than the administrator) to say that only show records where "Reviewer" is the current user. And the same for Edit permissions.
Photo of A Grobe

A Grobe

  • 90 Points 75 badge 2x thumb
Thanks for your quick response. I have 2 tables - 1 application have many scoring. I do not have a reviewer table. Manager of that application gives permission to 10 reviewers to review the application and add the scores to the scoring table. But on the scoring form, I wanted the information of the reviewer according to the user selected by the Manager on to the application. I was planning to create the reviewer table ... 
In that case it would be the scorings table, not the reviewers table.
Photo of A Grobe

A Grobe

  • 90 Points 75 badge 2x thumb
OK, thanks.