1 Reply Latest reply: Apr 22, 2015 2:08 PM by Anna Pochyla RSS

    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