I have a set of 2 drop downs. Once a selection is made in the first one, the second one popluates based on the first choice...I also have a a dynamic table on my page that works fine but shows every record from what ever recordset it is based on....here is what I want to happen....'
user makes a choice in first drop down, the second drop down then narrows down and shows those choices ( this all works fine up to this point currently) then when the user selects the second drop down selection. i want my dynamic table to show only records that corespond to the selection in the drop down

Example: user chooses Model of car drop down.....different models are shown in the second drop down...then user selects type model they have then my table only shows parts for this model....Please help ...I know it is pretty simple..i think it is just a simple sql statement or something ..but I am new and this is my first data driven web site to build...thanks so much
If it matters I am using Dreamweaver Cs3

Thanks in advance to all