dynamic menu system going to dynamic page

[Moragreid]

please can someone help me - im at the end of my tether!

ive got an access db. Its got a list of words that is to be a menu system
stored in it.

This menu system gets pulled through onto a page and a repeat region is put
onto it so the full set of records is displayed.

So now ive set the scene...how do i make these words (menu) into links that go
to a detail page that pulls through only the records relevant to the clicked
word? make sense? no...probably not...

here is my page [url]http://www.artdemo.co.uk/anniemos/content/jew_ears.asp[/url]

on the left there are a normal html links. when the white links are clicked it
goes into the db and finds only the records to do with "ears" and diplays them
all...then another db displays the sub menu system - which is the one im
finding problems with...where/ how do i get the sub menu linked and to the
detail page and how does the detail page know that it is to display only the
records for "ear4"???!

argh!!!! HELP!

[Paul Whitham TMM]

Create your menu so that it passes the name being searched as part of the
querystring, and then you can use this as a filter on the subsequent page.

For example your link would look like this

[url]http://www.artdemo.co.uk/anniemos/content/jew_ears.asp?submenu=ears[/url]

Then on the page it goes to simply filter the submenu recordset by a URL
parameter called "submenu"

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Moragreid" <webforumsuser@macromedia.com> wrote in message
news:d2k38j$d46$1@forums.macromedia.com...

> please can someone help me - im at the end of my tether!
>
> ive got an access db. Its got a list of words that is to be a menu system
> stored in it.
>
> This menu system gets pulled through onto a page and a repeat region is

put

> onto it so the full set of records is displayed.
>
> So now ive set the scene...how do i make these words (menu) into links

that go

> to a detail page that pulls through only the records relevant to the

clicked

> word? make sense? no...probably not...
>
> here is my page [url]http://www.artdemo.co.uk/anniemos/content/jew_ears.asp[/url]
>
> on the left there are a normal html links. when the white links are

clicked it

> goes into the db and finds only the records to do with "ears" and diplays

them

> all...then another db displays the sub menu system - which is the one im
> finding problems with...where/ how do i get the sub menu linked and to the
> detail page and how does the detail page know that it is to display only

the

> records for "ear4"???!
>
> argh!!!! HELP!
>

[The Wackonerd]

This is very close to my question at
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=263&thre[/url]
adid=984023&enterthread=y
but does not answer the second part of the question about the detail page.

How does the record get passed? I can do the menu section with the links but I
allways get the first record inserted.

[Moragreid]

Fab - ok - so ive got the menu passing url parameters - but the detail page is
pulling though all records instead of just the specified one i clicked...

i put a move to specific record on the detail page but it seems to be ignoring
it. So this is the URL im passing...
[url]http://localhost/anniemos/content/furniture_d_b.asp?RHMtitle=spoons[/url]
and i want only records with rhm_code to be equal to "spoons" to be pulled
though - any ideas?