I have two tables. One is a regional level table and other is a rep level table. So basically, the regional level table has no rep data to it at all. But the rep level table has region assigned to each row.
now i have two sheets in my app, one that shows regional numbers and one sheet that shows rep level numbers.
what i want is the following:
if a rep logs in the app:
1. in the rep sheet, he only sees his numbers.
2. in the regional sheet, he sees his entire region.
so if Rep A belong to Eastern Canada, he should only see Eastern Canada's regional numbers as well as Rep A's numbers.
I am unable to get both views working at the same time. I have the following data model:
I have a few fields that are similar between the Rep Table(RepActuals) and the Regional Table (FINAL) so naturally i have a synthetic key. Then i have the following in my section access script :
"ACCESS",//USER or ADMIN
SALINK//this reduction field is the userID of a Rep
GID //this field exists in the Rep Actual Table and is the ID of a Rep
But in this way, i only see the numbers at Rep level and not at Regional level. Could you point out as where i might be going wrong at this?