Ok here is my problem,

I am atempting to mod a current store front that a customer of mine uses. The database doesn't seem very well structured however they have alot of data already stored in it (witch i do not mind adding extra fields to the current Database)

ok now on to the question:

The table is designed as such

Code:
ID (Primary Key) - Text
Name - Text
Category - Text
SubCategory - Text
Description - Memo
OnWeb - Text

Ok so when someone does a search on the site (by catagory/keyword)
it executes this query:

Code:
	SELECT * FROM Products 
        WHERE (OnWeb = 'Yes') 
	AND (Category = '#Cat#') 
	AND SubCategory LIKE '#SubCat#'
	ORDER BY SubCategory
Now I can't see a way to list the data in the following way without a parent ID (witch there is none)

Catagory
-Subcatagory
-Item1
-Item2
-Subcategory
-Item1
-Item2
-Item3

And when someone does a master search for all to add Catagory into the drop down list

Catagory
-Subcatagory
-Item1
-Item2
-Subcategory
-Item1
-Item2
-Item3

Catagory2
-Subcatagory
-Item1
-Item2
-Item3
-Subcategory
-Item1
-Item2

Sorry for the long post just trying to be specific
Also if it is relevent I am useing an access database and the programing language is coldfusion (I know this is a MySQL forum however I think my error is in the SQL statment and no one in coldfusion knows the fix)

Thanks in advance

Mallek