JohnAeris
asked on
How do I lookup a field, compare to two tables and then enable / prevent access to Drill-through report?
On the left is a list of teams. The rightmost column contains a count of errors, if you click on count of errors you will drill-through to a detailed report that lists individual errors.
The report works and is fully functional!
However, I am trying to apply a security model that will restrict users to only view detailed error data for their own teams.
To illustrate: members of the Core Team can view details of the 943 errors but cannot view details of any details for the Adult Antenatal team.
Question:
I have created a lookup table that lists all users and the TeamCodes they can access.
I also have a table that lists all TeamCodes e.g. VHCAB and their corresponding Team Names e.g. CORE
I also have a table that lists all TeamCodes e.g. VHCAB and their corresponding Team Names e.g. CORE
Any thoughts on how I can look up the CurrentUser, lookup the team name compare it to two tables and validate if they can access the drill through or not?
TABLE LAYOUT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER
liija mate, thanks for your input. I realised that I had over complicated things and your input simplified my thinking.
thanks! :)