I have a CFM page where I list Category along with CategoryID in the drop down.
I like to be able to populate Category ID (in parenthesis) in the Category ID field when user selects the category from the drop-down menu.
For example, when the user selects "Picture Frames", then I want the page to populate 23 automatically into Category ID field as seen in the screenshot above.
Here are the codes in my CFM page
<CFQUERY NAME="GetCategory" datasource="DNSName" cachedWithin="#CreateTimeS
ORDER BY Category
<CFINPUT TYPE="text" NAME="CategoryID" SIZE=3 MAXLENGTH=3> Category Lookup: