How to make the items in dropdownlist to change when the a radiobutton is selected?

Hi,
i'm using sql server as my database.
How to make the items in dropdownlist to change when the a radiobutton is selected?


i've two radiobutton;
Food and Beverage; which belong to the group named: Category
when i select the beverage radiobutton, the dropdownlist will have the items from the database that belong to the beverage.
and for food too.




can any one helped me on this?


ps: beverage and food is two different table



...