When trying to use cascading looks up on SQL query controls on Nintex Forms, cascading lookup will break if the data in the column that the lookup returns has the following special characters: " - , &&, comma, # "
Create a calculated value that pulls the value of the first SQL Query control.
- Name the calculated control and add a formula.
- The formula will be "parselookup<name of first SQL Query control>".
- Configure the second SQL query to filter off the calculated value control and not the first SQL Query control.