Section Access query.

[knightwriter]

Hi all,

I have set a constrain in my section access and that works ok for the sheet I have applied it to (I have two sheets in my qvw). For example when the user logs in, they only see their assigned team stats on sheet 1.

The issue I am having is that this constrain is affecting the second sheet but none of the tables are related. So when that same member logs in they can only see partial information relating to that team on the second sheet.

Any suggestions how to fix this issue? 

[Gysbert_Wassenaar]

Apply section access to the data too using a section access table that links users to data values. See these blog posts:

A Primer on Section Access

Data Reduction – Yes, but How?

And these documents may be helpful too:

Introduction to Section Access

Section Access: Strict Exclusion