Hi
I am trying to make a site and the navigation is like yahoo style.
--------------------------------------------------------------------
A header like tree

main>cat1>cat2>cat3

and categories like

cat3subcategory1
top3 subcategories of subcategory1...

cat3subcategory2
top3 subcategories of subcategory2...

etc.

The database (access for now but going for sql server) has all categories 
in one table:
cat_ID,Name,parent_category_ID
---------------------------------------------------------------------
What I am doing now is
get the category_ID from a querystring
create a recordset for the header tree open it and close it again and again 
with loop
until parent_category_ID = null        (this is main  ) and create the 
string for the header.

create another recordset
loop where parent_category_ID = requestquerystring(categoryID)
make another loop  for every category inside the loop for the top3 
subcategories.

It works.
I want your suggestions how to make this perform better as it looks to me
that too much work with opening and closing recordsets.
Please put me in the right direction and if you need the code I can send it.
Any help will be very much appreciated
Thank you in advance
Best regards
Nikos