this is a very common question - check out this site for a good example:

http://www.asp101.com/resources/DependentLists.asp

hope this helps,

john