I have a few named queries setup on my project so I'm semi familiar with queries, but this particular problem is related to a text box that I want to populate with SQL data, depending on the selected dropdown "StepName".
Table: processsteps
Columns: StepNumber, StepName, Editor, Comments
I want to populate a textbox with Editor and Comment data when the particular StepName is selected. I have the dropdown data tied to an internal tag, and I'm trying to use that to point towards the correct row in the SQL table:
SELECT Editor
FROM processsteps
WHERE StepName = {[default]Internal/ActiveStepRecipe.value}
It does not like this, and I'm not sure if it's a formatting problem or linking the tag is where it's going wrong. Any thoughts?