Security Filtering

I am using the timesheet template. Several Contractors are working in the application. A signed in contractor via their email address can see only the records of their employees. This works fine.
I was asked to allow another user for the same contractor’s company to see the company’s data but as read only. How do i get different email addresses to link to a company and see its records?

Tables:
Team, -TeamId, Company, email
employees, - Empid, Name, TeamID, status
appuser, - AppuserID, Name, Company, Email, Role
roles - RoleID, Role

I want to filter the timesheet records by TeamID, based on useremail

0 1 165
1 REPLY 1
Top Labels in this Space