Section access case

[#1]

Hello,

I have a case with section access.

I have two users using the same document. There are two product groups - the one is responsible for the first, the other for the second.

They both need to see the sales of both groups however they can only see the profit of their own group.

Any idea how to do this?

[#2]

Hi ,
Yes u can try This

First u need to create a security table

Please find below tables ;

example

SecurityTable:
Load

SalesGroup      Division
ADMIN                         A      

ADMIN                         B    
ADMIN                         C   
ADMIN                         D   
ProductGroup1             A    

ProductGroup1             B     
ProductGroup2             C     
ProductGroup2             D      

join

Load
ACCESS  USERID   PASSWORD User Name  SalesGroup                         
ADMIN   qvadmin    123                  *                      ADMIN       
USER   *                 *                User1       ProductGroup1                         
USER   *                 *                User2       ProductGroup2                         

Hope above securitytable will work.

Regards-Bika

[#3]

Hi,

i am not sure how that prevents user1 to see the profit of sales from productgroup2?

If i have table like the one below and the user1 access it, he cant see only the red labelled data. And vica versa for user2..

User	Productgroup	sales	profit
User1	Productgroup1	sales1	profit1
User2	Productgroup2	sales2	profit2

It is neither row restriction nor column restriction... And i dont know any combined solution..