Hi all,
I wonder if anyone can help. In dw when I create a list or menu a dynamic link is associated to a names table and the value id of that is stored in a task list table. And all works fine, but what I need to do is create a report that displays the name from the drop down list without actually using the drop down list. dw does not allow single fields to create this association. The following is the code generated by dw. thanks in advance, john

<select name="nameid" size="1" id="nameid">
<option value="0" <option value="<?php echo $row_rsNamelist['nameid']?>"<?php if (!(strcmp($row_rsNamelist['nameid'], $row_rsTasklist['submittedbyid']))) {echo "SELECTED";} ?>><?php echo $row_rsNamelist['name']?></option>
<?php
} while ($row_rsNamelist = mysql_fetch_assoc($rsNamelist));
$rows = mysql_num_rows($rsNamelist);
if($rows > 0) {
mysql_data_seek($rsNamelist, 0);
$row_rsNamelist = mysql_fetch_assoc($rsNamelist);
}
?>
</select>