[caitlint]

I would have thought it would be easy to find a way to create drop down menus that are limited by other menus selected values.

What I have is about 12 drop down menus which are populated by values all in one view in a SQL database.

I would like to only show values in the menus for which there are data in the database with the other criteria met.

Since there is no way of knowing which criteria are selected my thought was to create a global WHERE clause string that I could remake each time something was selected.

Here is an example of what I have now.

Code:

               <td class="style2">
                    <asp:DropDownList ID="stack_plate_box" runat="server" Height="16px" 
                        Width="239px" DataSourceID="StackPlateID" 
                        DataTextField="plate_description" DataValueField="plate_id">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="StackPlateID" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:PerformanceDBConnectionString %>" 
                        SelectCommand="SELECT DISTINCT [plate_id], [plate_description] FROM [query_view]">
                    </asp:SqlDataSource>
                </td>

I would appreciate any help.

Thank you.