Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access: Restrict values in one table while keeping values in another

Hi,

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?

Thanks

1 Reply
Not applicable
Author

I'm struggling with similar problem.

The solution i found till now, was disconecting these two tables, by using different names for their fields.

The biggest disadvantage if this approach is the need of using more demanding functions it the visualisation.