dynaic menu

i have a menu box and all the values in it are dynamically selected from an access table. well i want to make the default value to
be something that's in another table. anyone know of a good tut for this?
thanks

oh sorry i'm using .asp
"jjrmy1" <jjrmy1 (AT) earthlink (DOT) net> wrote

i have a menu box and all the values in it are dynamically selected from an access table. well i want to make the default value
to
be something that's in another table. anyone know of a good tut for this?
thanks

do you mean where one data1.column1 = data2.column1 (another table), or the
first item is selected?

if the first item in the list, look at the code view for yr menu. See the
<option value=""></option> section.
Type in another one, from yr Server bindings panel drag the appropriate
column names onto the page
<option value="<?php echo $row_rsYear['yearID']; ?>"><?php echo
$row_rsYear['year']; ?></option>

To make an item selected based on equal values, when you click the 'dynamic
data' button for a menu it opens the selection window for the dynamic data,
at the bottom of which is a link (the lightening bolt), this link allows you
to select the column from a 2nd table on which value you will compare
<option value="<?php echo $row_rsTheme['ptheme_id']?>"<?php if
(!(strcmp($row_rsTheme['ptheme_id'], $row_rsCat['pcat_id']))) {echo
"SELECTED";} ?>><?php echo $row_rsTheme['theme']?></option>

Craig



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

i have a menu box and all the values in it are dynamically selected from
an access table. well i want to make the default value to
be something that's in another table. anyone know of a good tut for this?
thanks