Question
Database Driven Navigation
Hi all.
I have a table of product types which I write to the page with Repeat Region. Under those product types I need to place subcategories and loop through those. Basically I need to add a Repeat Region within a Repeat Region but I only want the Categories for that Type. The result would look like this:
Product Type 1
Category 1a (CategoryName WHERE CategoryID=TypeID)
Category 1b
Category 1c
Product Type 2
Category 2a
Category 2b
...
My relevant tables are:
producttypes
TypeID
TypeName
productcategories
ProductCategoryID
ProductTypeID [foreign key TypeID for producttypes]
ProductCategoryName
I'm thinking the inner repeat region has to be something like:
do while TypeID=ProductTypeID
But not sure how to go about doing that. Any pointers appreciated.
Thanks,
I have a table of product types which I write to the page with Repeat Region. Under those product types I need to place subcategories and loop through those. Basically I need to add a Repeat Region within a Repeat Region but I only want the Categories for that Type. The result would look like this:
Product Type 1
Category 1a (CategoryName WHERE CategoryID=TypeID)
Category 1b
Category 1c
Product Type 2
Category 2a
Category 2b
...
My relevant tables are:
producttypes
TypeID
TypeName
productcategories
ProductCategoryID
ProductTypeID [foreign key TypeID for producttypes]
ProductCategoryName
I'm thinking the inner repeat region has to be something like:
do while TypeID=ProductTypeID
But not sure how to go about doing that. Any pointers appreciated.
Thanks,
AdChoices