dynamic list/menu

I would greatly appreciate any advise on this. Thanks
I'm using access tables and .asp.
a list of catagories is kept in one table, in which a dynamic list/menu box connects to to give your choices.
The current catagory is inserted and kept in another table (with other information). I need the initial value of the list/menu box
to be the current catagory.
Does anyone know how i can get the list/menu box to have the values of one recordset and the initial value of another recordset.
or you if you could direct me to a good tut.
thanks.

Hello jjrmy,

1. Create a recordset just for the purpose of populating the list. (Don't
actually add it to the list yet.) rsMyList

2. Create the recordset used for display on the page. rsMyData

3. Set up the page to display the data. (Still don't add the data to the
list menu yet).

4. Click the list menu in Design view and then click the Dynamic button on
the Property inspector.

5. Options from recordset should be set to the recordset for populating the
menu. Set the Values and Labels fields accordingly. The key is, set the
Select value equal to the appropriate field in rsMyData. To do so, click the
lightening bolt, and choose the field in the dialog that appears.

That's it!

Good luck,
~Angela
--
Angela C. Buraglia, Founder:
~FAQs, Tutorials & Resources~ http://www.DreamweaverFAQ.com
~My Extensions~ http://www.dwfaq.com/go.asp?ID=AngelaX10
DWfaq Support Newsgroup: news://support.dwfaq.com/support

Co-Author with Joseph Lowery, Dreamweaver MX 2004 Killer Tips:
http://www.dwkillertips.com

Extension Developer for Cartweaver 2:
http://www.cartweaver.com/features/extensionsuite/

Remove the CAPS in my E-mail to reply off list.


"jjrmy1" <jjrmy1 (AT) earthlink (DOT) net> wrote

I would greatly appreciate any advise on this. Thanks
I'm using access tables and .asp.
a list of catagories is kept in one table, in which a dynamic list/menu
box connects to to give your choices.
The current catagory is inserted and kept in another table (with other
information). I need the initial value of the list/menu box
to be the current catagory.
Does anyone know how i can get the list/menu box to have the values of one
recordset and the initial value of another recordset.
or you if you could direct me to a good tut.
thanks.