Filter Data Form web part from a drop down menu
Posted on 2011-03-03
Hi, I have two data form web parts on my page in Share Point Designer 2010.
The first one pulls in a single column from a list called 'User name' (people or group field)
I then have another data form web part that pulls in several columns from a traning course list about courses (ie: course description/couse Name, course cost, and Attendees (person or group field)
What I need is that when the user name is selected from a drop down menu (in the Students web part), all the courses (in the courses web part) that have that user name in the attendees field, show.
So I changed the first data form web part that filters the user name to a drop down design, so the user can select a single name from the drop down menu. I then connected this web part (called students) to the other web part (called courses), using "send row of data to" then set the column in the source web part (user name) in the same row 'Attendees in the 'Courses' web part. Now it works if the source web part (Students) doesn't have a Drop down design) I think it's because it want to create a hyper link when joining the web parts, and drop down design doesn't have a hyper link, it's an option. So my question is, how can I filter the data form web part from another data form web part that is of drop down type.