We are trying to load a combo box list based on the value in a previous combo box.
Our Query is:
select ContractName as QuestionOption, CSC as QuestionOptionValue from Contracts where CSC = '$(CSC)'
The value we are passing (CSC) is the short name of the previous combo box.
When we hard code the value for the CSC, we are able to get a positive result. However, we are not able to get any result based on the actual query above.