I have a requirement like this.
- Junior Admin (1)
-- User 1
-- User 2
- Junior Admin (2)
-- User 3
-- User 4
Now.. I made a document for Admin user. He can see all details of Junior Admin 1 and 2 and their corresponding users. If Junior Admin 1 and 2 opens that document than only they are able to see their correpsonding users respectively not each others detail. Junior Admin 1 cant see any detail of Junior Admin 2 and vice versa.
How to achieve this requirement ? Any suggestion ?
You need to create kind of an hierarchical structure like
Think the principle is clear. Table may also be constructed with JOIN-operators