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......