A customer has asked me to build a new commitment tracking system for them in Sharepoint. They have created a need for 3 types of commitments that we can just call TypeA, TypeB, and TypeC. There is also several different departments that need to be able to create these 3 types of commitments. There are 2 departments that can create the TypeB and TypeC commitment for any other department and only they can create TypeB annd TypeC. The TypeB and TypeC commitments can only be seen by the departments that they apply to and the 2 departments that created them. TypeA can be created by any department but only exists for that department.
I had several ideas but wondered which one would be the best.
Create the 3 Types as 3 seperate content types derived from the task content type. Create a single list attaching these types to the list and then create folders for each department. Use groups to control the permissions.
Create a list that derives from the task list or make a custom list. Create permission sets or groups that have the correct permissions and then use an event receiver on the list that uses the metadata of the item being added to check which department is assigned to and apply the permissions at the item level.
Create a separate list for each department and add the content types to each list. This seems rather crude as reporting would be more difficult.
Does anyone have a better suggestion or idea??
UPDATE 6-11-2011 This is an older post, but this project had fallen in priority and is now back on. I have written a blog post that I hope details it better here