From: larksys on
The following grid provides the correct drop down list but when displaying the
value of the column it show the actual value and not the display value that I
want. It should be showing initials and not the ID for those initials stored in
the database.

You can go to tax.avericom.com/control and log in as temp/AdobeLabs. On the
drop down menu select client services then client searches. Type 2478 as the
search number in the top box then select it from the list. When the next page
loads, click on the candidates tab. The recruiter_referral column should show
the drop down. If the entry is blank the drop down works properly. If it is not
blank, only the selected item show. The value in that column shows the stored
value from the database and not the corresponding value from the list.

<cfgrid
format="html"
name="searchIndivsGrid"
bind="url:panels/panelcandidates_2.cfm?searchnum=#searchnum#&page={cfgridpage}&p
ageSize={cfgridpagesize}&sortCol={cfgridsortcolumn}&sortDir={cfgridsortdirection
}" bindonload="yes"
width="1200"
selectonload="no"
pagesize="20"
selectmode="edit"
onchange="cfc:candidates.UpdateIndivsBySearchNum({cfgridaction},{cfgridrow},{cfg
ridchanged})" autowidth="yes">

<cfgridcolumn name="search_number" header="Search" display="no"/>
<cfgridcolumn name="individual_number" header="Individual" display="no" />
<cfgridcolumn name="lastname" header="Last Name" width="30"/>
<cfgridcolumn name="firstname" header="First Name" width="30"/>
<cfgridcolumn name="Date_Of_Resume" header="Resume" width="20"/>
<cfgridcolumn name="consultant" header="Consultant"
values="#valuelist(QconsultantList.id)#"
valuesdisplay="#valuelist(QconsultantList.initials)#" width="20"/>
<cfgridcolumn name="Active_Until" header="Active Until" width="20"/>

</cfgrid>