Section Access with more than 1 reduction column

[pmenchon]

Hello, I have a problem with trying to secure my app creating the section access table.

I need to link with more than 1 reduction column for example:

Section Access;

LOAD * inline

[ ACCESS, USERID, COMPANY, DEPARTMENT

USER, AD_DOMAIN\ADMIN, *, * 

USER, AD_DOMAIN\A, COM1, DEP1

USER, AD_DOMAIN\B, COM2, DEP2

USER, AD_DOMAIN\C, COM3, DEP1

];

In this case, I want to filter data by company and department but this is not working.

How can I use more than 1 column for that? Is it possible?

Thank you all.

[Levi_Turner · Accepted solution]

Use of a link table is the standard approach for accomplishing this. This video is quite good on a brief primer on the technique.

[pmenchon]

thank you!