I am putting the following section access code in my QV file
SQL SELECT UPPER(username) AS NTNAME,
case UPPER(username) when 'ST12\ARIF' then 'ADMIN' else 'USER' end AS ACCESS
Then I load the rest of tables. The tables are interlinked as following
The problem is that the branches, desks etc are visible to users based on data reduction (Consultantdesk table), but data in other tables are not visible to any users. Is it because the section access is joined to consultantdesk table but not directly linked with other tables? What is the problem with my logic?