I have two list web parts on my page.
The first list has two columns: user name and ROLE. A user can be listed more than once if they have multiple roles. The view used returns only the roles for the current user.
The second list has two columns, one for role and one for SKILL.
I would like the second list to return all skills which match the roles listed for the user. Currently I can only filter the skills list one role (or row) at a time, SharePoint adds a 'Select' column to the roles list for the user to select which role they want to view. Is there any way to filter the SKILLS list by all roles returned in the ROLES column?