Database Driven Navigation

[-- ND --]

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,

[Newsgroup_User]

"-- ND --" <nduckworth@gmail.com> wrote in message
news:fp4v48$nla$1@forums.macromedia.com...
> 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.

http://www.tom-muck.com/extensions/help/simulatednestedregion/

[-- ND --]

Thanks Hunter. I don't think this will work with a nested list, at least I can't get it to work. Works if I just use BRs to separate the types and categories, but I don't want to go that route for my navigation.