I have two tables; Table1 has fields A and B, Table2 has fields A and D.
I've set up section access with reduction on field B:
SECTION ACCESS; LOAD * INLINE [ ACCESS, NTNAME, B ADMIN, domain\user, * USER, domain\user, value ]; SECTION APPLICATION; ...
The problem I'm struggling to solve is that everything from Table2 is being excluded, which is understandable as field B doesn't exist in that table. Do any of you know of a way that I can circumvent this, and restrict the values in Table1, whilst excluding NO values in Table2?