Datbase driven drop down menu

I have an access table:
  ID (primary), title, parentID

This table represents a menu system with submenu capabilities. An implementation could exist as follows:

- Pets
  - Cat
  - Dog
- Cars
  - Mazda
-----------
ID       title        parentID
1       Pets            -1
2       Cars            -1
3       Cat              1
4       Dog             1
5       Mazda          2
-------------

I would like to populate a select list (drop down menu) with a list of categories and subcategories under them. Is there a quick way to do this without using 2 record sets? Please provide the code if possible.


Here's the stuff I have now:


<select name="categoryID" id="categoryID">
<%
      Query = "SELECT * FROM offerCategories"
'the following line executes a query and puts the results in recordSet
      opentable
      do until recordSet.EOF
                   Response.write "<option value=""" & recordSet("ID") & """>"
                   RecordSet.moveNext
      loop
%>
</select>



this creates a drop down list with each of the categories in it, but does not display anything in the hierarchal structure that i desire. I would like for it to look more like this:

: Pets
   : Cat
   : Dog
: Cars
   : Mazda

So there is a special order based on parentID that is created, as well as the potential for multiple levels of submenus. I just need to know an efficient way to do this that doesnt require simutaneous record set traversals.Start Free Trial