ASP

I am basically writing a code, asp, connecting to an MS Access DB. The form basically has 10 inputs, drop-down menus. A user can select 1, or 2, or 3, or 4 and so on and so forth selection of the ten menus. So far I wrote a code in asp and sql that using if…statements for 4 of the menus. When I calculated how many I have to write !!!! I was shocked !! I think it is more than 800 different startements !! 🙁

My question is DO YOU KNOW any alternative to this solution!! The if statements for 800 is too very much !!

Thanks for your help