How to filter with menues

[inspiro_swe]

As a total newbie to "one to many" relationship databases, I am wondering how
to sort out a recordset of posts under a categorie - using two dynamical menues
i DW?

The first menue would decide wich values the second one would hold. Based on
those two menues values a recordset can be choosen. I have a foreign keys in
the 2 of the three tables Im using.

The "chain of command" is: Table1 ------> Table2 (forign key to table
1)---------> Table3 (forign key to table 2)
I guess you can say that table 2 and 3 are subcategories to table 1.

How do I do to filter table 3 out - in a smart way? :confused;

[twocans]

[url]http://www.webthang.co.uk/tuts/tuts_dmx/gk_search1/multisearch1.asp[/url]


regards

twocans



"inspiro_swe" <webforumsuser@macromedia.com> wrote in message
news:d1ok2i$7f4$1@forums.macromedia.com...

> As a total newbie to "one to many" relationship databases, I am wondering
> how
> to sort out a recordset of posts under a categorie - using two dynamical
> menues
> i DW?
>
> The first menue would decide wich values the second one would hold. Based
> on
> those two menues values a recordset can be choosen. I have a foreign keys
> in
> the 2 of the three tables Im using.
>
> The "chain of command" is: Table1 ------> Table2 (forign key to table
> 1)---------> Table3 (forign key to table 2)
> I guess you can say that table 2 and 3 are subcategories to table 1.
>
> How do I do to filter table 3 out - in a smart way? :confused;
>

[inspiro_swe]

Thanks a million! But is there a way to do this not leaving the page?

It would be really neat to have navigation possiblities still at the top of
the page of the recordset (posts)....

Im trying to do this in PHP/mySQL....

Thanks

[twocans]

I dont understand what you mean.

you could try a dreamweaver extension
[url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Benefits/Details/Dependent+Drop-downs.html?id_sol=16[/url]

other then that the tutorial from webthang link i send you should explain as
to how to create what you want.

regards






"inspiro_swe" <webforumsuser@macromedia.com> wrote in message
news:d1onl9$e9e$1@forums.macromedia.com...

> Thanks a million! But is there a way to do this not leaving the page?
>
> It would be really neat to have navigation possiblities still at the top
> of
> the page of the recordset (posts)....
>
> Im trying to do this in PHP/mySQL....
>
> Thanks
>

[inspiro_swe]

Thanks anyway! I got it sorted out.
I guess I didnt explain the problem very well....

I just selected a value equal to a variable that the menu itself sended so
that I could "fill in" multiple entries in an URL-string. (So you could see
what you allready choose before in the previous menu)

Then ofcourse it was just to get the SQL-querys right for each recordset
populating each dynamic menu. (depending on the given value of the menu before)

Beeing a total newbie at this I still have to do serious testing though....

Thanks anyway for the great links and support!