# Revision history [back]

For some reason, the query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for display and one for the underlying value.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"


For some reason, the query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for display the ECN name and one for the underlying value.ID.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"


For some reason, the query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for the ECN name number and one for the underlying ID.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"


For some reason, the query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for the ECN number to display and one for the underlying ID.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"


For some reason, the query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for the ECN number to display and one for the underlying ID.ID. Here is the corrected query.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"


For some reason, the The query in CustChange2 is looking in the wrong table. Also, it should grab two fields: one for the ECN number to display and one for the underlying ID. Here is the corrected query.

sSql = "SELECT ""ECN-RFQ Reference"", ""ECN-RFQID"" FROM ""ECN-RFQ"""&_
" WHERE ""CustomerID"" = '" & sSelectedValue & "' ORDER BY ""ECN-RFQID"" ASC"