I've followed the example found here: wss.collutions.com/Lists/FAQ/DispForm.aspx?ID=202 to create a few connected dataviews on a page that are filtered through Drop Down lists.
such that I have 3 DVWPs:
1. DropDown Style of Categories
2. DropDown Style of SubCategories
3. Normal table layout style of Documents
When I select an item in the first box, it fires the connection to the second and the second shows the filtered list of subcategories, but the first box has gone back to "Choose One..." If I select a SubCategory, the connection fires and the 3rd DVWP of Documents is filtered correctly, but the 2nd Drop Down also goes back to "Choose One.." If I then perform any sort of post-back such as sorting the 3rd DVWP the data reverts back to as if I had not selected anything in the dropdowns. I thought it may have something to do with the first record being sent automatically by the WebPart, but the behavior is basically the same whether this option is checked or not. Is there any way to make the DataView hold onto the selections I've made so that the connected webparts contain the correct data?
BTW.. this behaviour is the same no matter what style the DVWP's are, which seems to make it almost useless to use DVWP's connected to each other except for when you'll never have a post-back.