Probably a very simple question. In my database table occasions i have the fields "brand" and "type". Now on my search page all brands and all types can be selected (there is no relation between brand and type). How can i make sure that if a brand is selected only the corresponding types will be shown in de type drop-down box. Of course i would like to have this working the other way around as well.

Thanks,
Hans