I have CFM page where I populate the data from currently selected record (from prev. cfm page using CFGRID), allow users to edit the contents of data and let them save the changes.
The question is how I can display what is already in the record for category and designer fields, but at the same time, let the user change the them from the drop down if they wish to choose different category or designer. Same question applies to Status field, but the only difference is that Status does not have a table. It is just a one char field with three possible values - A, I or D.
If I have not explained myself clear, please let me know.
<CFQUERY NAME="FindItem" DATASOURCE="DSNName">
WHERE ID = #cfgridkey#
<CFQUERY NAME="GetCategory" datasource="DSNName">
<CFQUERY NAME="GetDesigner" datasource="DSNName">
<CFSELECT NAME="CategoryID" query="GetCategory" VALUE ="ID" DISPLAY="Category">
<CFSELECT NAME="DesignerID" query="GetDesigner" VALUE="ID" DISPLAY="DesignerName">
<CFINPUT TYPE="text" NAME="Status" SIZE=2 MAXLENGTH= 2 VALUE=#FindItem.Status#>
<SELECT SIZE="1" NAME="Status">
<OPTION VALUE="D">DON'T LIST YET</OPTION>