I have a custom list which has a property "Department" which is a multi-select checkbox list. So each item in this list can be one of multiple different Departments. I would like to make these items only available to people in that given department. For example, if someone is in the "Accounting" group on the SBS, can I make the custom list so that user can see "Accounting" specific items and no others?
In the same sense, if someone is a part of multiple different departments, they should be able to see all items which fall under each department.
I'm using SharePoint 2010 integrated with SBS 2011.