I have a Leave Form and I am trying to get a cascading dropdown setup working so that I can basically double filter a lookup. there are plenty of resources for this here but I cannot seem to get mine working. There are a couple of subtle differences between mine and the examples but nothing I would expect to cause the filter to fail.
I set up a dummy solution to reduce any extraneous complexity in my production form from getting in the way.
Example for is very basic... Just the default content and two list lookup controls
The first control successfully looks up an employee name from a list on another sub site.
The next lookup control looks up the contract period from a TimeBank where an employee's available leave is stored and filters off of the FullName result of the first lookup control.
The issue I am having is that the second control does not filter. The list connections seem to be working because when I select filter by specific value on the control and enter a known FullName, the form filters by that name.
Here images images of my results.
This form was based on: https://www.youtube.com/watch?v=Xx5q31FZF9g (Create a Cascading Drop Down in Nintex Forms for SharePoint) after seeing in in a post recommended by Cassy Freeman and Marian Hatala.
Any help would be appreciated!