Here is my requirement: I have a list of region/offices that is used to model the organization structure of a company. This list is used as a lookup in a list of manager users: so each manager is assigned to a region that he/she will manage. That means each of the node below will have manager assigned to them.
Europe Region --East Europe ----Greece Office ----Turkey Office --West Europe ----England Office ----Netherlands Office --North Europe America Region ... ...
Then I will have another list, that holds the staff(personnel) information for these regions/offices.
Name Phone Email Age Region (Choice) Office (Choice)
What I need is to implement some policy so that the managers of the regions/offices will only be able to enter/update the information of their staff.
That means, the manager of Turkey office will not be able to enter data for Greece office. Or the manager of Europe Region will not be able to see the data of America region. Which should need a hierarchial permission structure.
How can i provide this kind of permission structure in SharePoint. The only solution that comes to my mind is developing a custom NewForm and EditForm, then do the permission checks in code-behind.
What are your ideas? Any alternatives come to mind?