I have a lookup set to displays results based on a drop down selection.
When I create a second lookup to populate the drop down selection, with a large set of values to choose from, for every value this lookup returns, the first lookup runs again.
So the first lookup runs 800 times. Why would this be? Lookups should only run when the form is first loaded and when the user makes a change, not as lists are being populated by other lookups.
Update:
Ah I found the issue. It appears the lookup triggers a change for every value it enters into the field. Since Forms has this issue where it keeps inserting blank values as choices into drop downs I have javascript preventing blank from being chosen.
This is because for some reason forms does not let me remove it even though I looked up the correct syntax. So Instead when blank is chosen I have to force choosing another value.
$('.noblanks select option[value='']').remove();
So the lookup for every value triggers a change and chooses the one choice I don't want available, which is [blank] 800 times. If I could just remove this from my drop downs javascript would not be required. Normally you must tell the system you want to "add blank as a choice" when creating drop downs, but in Forms it does it anyways.