Suppose that i have two lists like this
REGION_LIST [ RegionName(text), RegionResponsibles(multi-select peoplepicker) ]
ISSUES_LIST [Some issue related columns, Region(lookup) ]
Main requirement is that system should only let the related RegionResponsibles to enter issue for that Region, and also in the list view RegionResponsibles should only see the issues for regions which they are member of.
The thing is; i can programmatically create SPGroups and assign people to those groups than do item-level unique permissions for each issue item. BUT; sharepoint has boundaries and limits for lists containing lar number of unique permissioned items.
As my list will probably have large number of items, i am looking for a solution that i dont have to create unique permissions for each item? Does sharepoint offer any other solutions to these kinds of requirements?
I am now thinking of programmatically check if the user is eligible to add/update item for any region in custom Event Receiver and prevent in ItemAdded/ItemUpdated . That is ok for data entry. But what about viewing only the items they are related to? Any ideas are welcome. Thanks.