Relational value lists on the web (cdml)

[Kyrre]

Greatings

Sorry if this has been talked about earlier.

Case: I have a produkt database with aprox 1000 products. In the database I have three dynamic value lists (from three fields in the database):

cat1 = main category

cat2 = sub cat 1

cat3 = sub cat 2

There are 8 main categories. In the 8 categories there can be several sub categories, and under these sub categories there can be several categories. The products can not be listed until all three categories has been run through.

Now, I want to click on a main category and have a list of all the sub categories corresponding to the main category I clicked on. Then I want to click on a sub category showing sub 3 categories corresponing to the sub category I clicked on, and finally when clicking on cat 3 showing the products in this category. My mind is confused already...

I have no clue how to fix this - not in the database, nor on the web with cdml. Anoyone?

Regards,

Kyrre, Oslo, Norway

[BuddySystems]

There are a couple ways I can think of to do this: the first of course is the "static" way, which is to do multiple pages with get forms that basically show the results from the previous form post and the results on the next page. The down side of this is that you are getting/posting multiple times and there is a couple-second pause when it happens.

The other way to do this is with javascript calls that do the same thing, making it look far more dynamic. I've seen this done, and can point to a consultant who can do it for you pretty cheaply. Email off-list if interested.