I am using Nintex Workflow Cloud. I have two MS SQL Server on-premises data sources; each connected to separate tables in the same database. The two tables have a common key (ID).
I want to use data lookup 1 to find the desired ID in Tbl1 and use that ID as a filter on data lookup 2 to limit the results returned to just those items in Tbl2 that have the ID selected in data lookup 1.
I configured two Data Lookup controls on my Form. The first is connected to Table 1 on ID. That ID value is stored in a Text control on the form using a Rule.
The second lookup is connected to Table 2. I want to look up only the items whose ID is the same as the ID from lookup 1.
However, when I attempt to Add a Condition to Data Lookup 2, I am unable to select either a Form Control or Form Variable as a Value for the condition. They are Greyed Out.
I also tried a Form Variable, but it is Greyed out too.
I have verified data types, and the ID field is a Text value in both Tables and in my Form controls and my Form variables.
Anybody else have this issue with a Data Lookup control connected to a MS SQL Server On-Prem data source?
Is there a fix or work around for this issue?
Please advise.
Thank you.
