Hi,
For Sharepoint Designer 2007,creating a dropdown list is abs simple,even if data binding is needed.Place an ASP.NET control onto a page in SharePoint Designer and then use that control as the mechanism for filtering a Data View on the page.This can be used for any Asp.Net control be it a textbox,checkbox,radio button etc.
Now,As Drop Down list is a concern here,
1>Create two lists List A ,List B.
2>Once you insert the Drop down List,click the smart panel that would be your Data Source
3>Your datasource would be for ListA i.e.[SPListDataSourceA]
4>Display would be List A
5>Make sure,its value is also List A.
6>Insert 2nd Asp.Net Drop down List,List B
7>In Smart Panel,select AutoPostBack == True
Very well the list can be dragged within the page to create a Data view Web Part.
8>Now,again in Smart Panel,select Edit Columns,the columns which are necessary for display.
9>Finally ,you can filter the Data View Web Part.
10>It can be filtered as
Field: List name A (or the field that contains your List parameters)
Comparison: Equals
Value: [Create a new Parameter]
Param Name: Param1[random]
Source: Control
Control ID: DropDownListA
Default: [any random value]
After OK.
11>Save the page
12>After the changes,If you feel according to UI for Drop Down List,well can go ahead ,else changes can be made in the filter
I guess,this should work well.
-Archana.