I am running Sharepoint Foundation on Windows 7. I am trying to filter a list based upon the user group a person may belong to. If the current user is member of the Division Managers group, then the division that they supervise will be retrieved. I would like to filter the task order list by the Division field so the the division manager sees all task orders that have been assigne to their division. If the current user is a member of the section manager group, then the section id that they supervise will be retrieved, and the task order list will be filtered by the section id field. So they will see all task orders assigned to their section. How do I do this and are there any filter web parts available to me in Sharepoint Foundation? Thank you.
Richard