I have a look up control in 'List A' that points to 'List B.' List B has a checkbox field called 'Active.' I only want items from List B to appear in the look-up control in List A IF their 'Active' box is checked. How can I do this in Nintex Forms? In another vendor's solution, one of the preference settings for such a cascading lookup situation was to select which list view in List B should supply values. So, I would create an 'Active' listview which would only display items where the 'Active' box is checked. This worked nicely. I haven't found anything similar in Nintex.
In the future, some of these values may become inactive, but we would want past items in List A to still retain such inactive values in the lookup control. Therefore, we cannot delete such items.
To put a spin on it, this lookup control would first be filtered by a preceding Lookup control based on another field in list B as supplied by List C. I already have this working. But, I need to introduce the 'Active' checkbox portion, too.
Any help would be appreciated.
