could someone help me with is asp dropdown menu

Originally posted by : mark (marks@thrivemedia.com)I'm trying to creat a drop down menu which will be auto generated from a data base. the database have 2 table, one is holding the category and another is holding the content.in this drop down menu, I want to display all the different category and the number of the record under each category.The way I know how to do this is like this:go through the category table and pull out diferent category one by one,then open the content table searching for the record under each category, then use howmanyrecs=rs.recordcountget the countis there a better way to do this so I don't have to open the record set and search the content table for each category?Thank for helping.