need help with a search form i've been asked to do for a friend.
i've done forms in the past, but not one like this. there will be 2 pick
lists on this form. to keep things simple, the database has 2 fields: main_heading, and sub_heading. I can generate the first pick list by using a select distinct to get a unique listing...but the second pick list has to be generated by what is choosen in the first. can i do that on the same page ?

thanks. !!
scott