I’m trying to create a form where the user simply chooses their name from a dropdown list that is constrained by the name of their company (a particular company in the database). The idea is that only associates from that particular company will display in the dropdown box.
However, when I go to create a constraint on Search for Associates and try to set it to Company = value I’m looking for, it won’t allow me to choose a company name (endless loop of searches). It won’t allow me to type in a value. I even tried creating a hidden input and a hidden dropdown with the value I’m looking to use and then use the value of that hidden field as a constraint for the dropdown menu showing the names. While everything shows up in blue this way, no names show in the dropdown list when I have two entries in the database for that company.
How can I get this constraint to work? Why is it being so difficult?