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

Question

One&nbsp;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&nbsp;I create 10 users fields in the Application Table and&nbsp;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.&nbsp;What is the best way to handle this?&nbsp;

suryaexpert · Answer

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.

annug · Answer

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&nbsp;to the user selected by the Manager on to the application.&nbsp;I was planning to create the reviewer table ...&nbsp;

suryaexpert · Answer

In that case it would be the scorings table, not the reviewers table.

annug · Answer

OK, thanks.

Forum Discussion

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

Related Content

Using GetRecords to query a table in a different application?

Sr. Analyst / Application Developer Needed

Update on the retirement of Application Webhooks UI and QB Actions

Legacy Form use in Mobile Application

Application Access Requests