I have a field called "(Order)Processor" and on order form, I have the following code:
When Shari is chosen in drop-down, then the system actually stores "email@example.com" in the table and no problem here.
But when I query the record that has processor with "firstname.lastname@example.org", how can I display the drop-down menu using CFSELECT and make sure Shari is selected but list other processor names (Amy, Lyndsay and Teri) at the same time so that users can pick another order processor if they like to do so?
<CFQUERY NAME="FindOrder" DATASOURCE="Order">
WHERE ID = #cfgridkey#
Note. I don't have a separate table that stores (order) processor names and their email addresses.