Share record with associate records N:1

(0) Share

Report

Posted on by ampatil13@gmail.com

115

Hi,

I am trying to build security module based on below structure

Account1:
Location 1:
Product 1 : Shared this record with user1 so user can access only Product 1 , Location 1 and Account1
Product 2 : Shared this record with user2 so user2 only access Product 2 and Location 1, Account1
Location 2:
Product 3: Shared this record with user3 so user3 only access Product 3 and Location 2, Account1
Product 4.: Shared this record with user4 so user4 only access Product 4 and location 2, Account1

So as per above structure 1 Account has multiple locations and multiple products

so I am trying to implement security module like if i shared record Product 1 then associate to product Location1 also shared and with location1 associated Account also shared

please let me which solution approach is best for this structure

Thanks in advance......