How do I apply a filter to a select statement?
I've tried every combination I can think of, but nothing is working. I have a variable that I'm carrying over from a previous screen, and I'm trying to then set another variable on page load on another screen based on that first variable from a data master. In essence, doing a simple select SQL statement... SELECT ColumnB FROM DataMaster WHERE ColumnA = VariableA. I'm trying to do this using a calculated set value on page load. I've tested it without the filter, and I get all the values. I've also test the variable, and it shows up on that page as well, so I know it's being carried over. The following image has been my best guess. Thanks for your help.