Hi!
I´m trying to apply a little complex type of Security Access into my QlickView report.
I have four columns of data:
| Employee | Country | Salary | Supervisor |
| John | USA | 4555 | Kevin |
| Kevin | Canada | 3425 | Maria |
| Peter | USA | 6000 | Carter |
| Carter | USA | 1345 | Estela |
| Maria | Argentina | 9000 | Kevin |
| Dolores | Brazil | 3456 | Mike |
| Estela | Colombia | 7654 | Kevin |
| George | USA | 2866 | Mike |
| Mike | Canada | 3333 | Estela |
| Ruben | Argentina | 1234 | Estela |
| Carlos | Colombia | 7689 | Mike |
On my report each USERID is a Supervisor and I need that each USER (Supervisors) can see the data (Salary, etc.) of all the people of his Country and also the information of their supervised people.
For example: USERID "Kevin" should see all the info of people of USA (John, Peter, Carter and George) AND the info of their supervised (María and Estela).
I´ve created this Access file but it doesn´t works.
| ACCESS | USERID | COUNTRY | EMPLOYEE |
| ADMIN | ADMIN | * | * |
| USER | Kevin | USA | |
| USER | Kevin | | Maria |
| USER | Kevin | | Estela |
| USER | María | Argentina | |
| USER | María | | Kevin |
| USER | Carter | USA | |
| USER | Carter | | Peter |
| USER | Estela | Colombia | |
| USER | Estela | | Carter |
| USER | Estela | | Mike |
| USER | Estela | | Ruben |
| USER | Mike | Canada | |
| USER | Mike | | Dolores |
| USER | Mike | | George |
| USER | Mike | | Carlos |
There is a way to apply this type of Access Level?
I attach the files if you can try.
Thanks!
