Connections between Web Parts
I've searched and searched and found nothing about it.
I have SharePoint Designer 2007. I have a SharePoint website, here what I need to do.
I have a DataFormWebPart showing a DataBase Connections, but I guess it could show any data, that's not the point. I have that WebPart.
What I need now, is another WebPart that is a filter and for the user to show specific row in the DataFormWebPart. I know I can put something like a SimpleFormWebPart that can have a TextBox or a DropDownList with value in it to filter my list.
But, what I want is:
A DropDownList that contain all the differents rows of my list. I need to do that programmaticly, not enter manually each one because I want to re-use that WebPart. Then, an associated TextBox that will be used by the user to enter a value depending of the DropDownList value he chose.
Exemple:
I have my list with ID, Name, Age. My DropDownList will need to contain those.
The user will be able to chose let say, Age and then in the text box put 19. Click then on the Go button. It will show then only the row of the people who got 19 in the Age column.
P.S: If you got not idea how to do it, if you know how to populate a DropDownList form a WebPart that contain the value of a certain Row of my list in the DataFormWebPart, like all the differents Age.
Conclusion: I need a WebPart that take the value of the row form a DataFOrmWebPart containing a list and put them in a DropDownList, there is also in that WebPart a TextBox and a Go button. When I send the filter with the Go button, it take the chosen DropDownList value as the row to check and in that row check the value that the user put in the TextBox.
