I have a lookup that contains several inputs. I would like to hide the auto fill button. When I do this, the form becomes essentially useless because it is so slow. I see that when I hide the auto fill button, the lookup rule is run every time there is a change in a match field from the form. Is there anyway to have the auto fill button pressed only when a specific input is changed?
See the image above. There are 9 inputs. The stored procedure takes ~ 1 second to execute in SQL. However, in Forms it takes about 15 seconds every time the user updates a field because it re-runs the procedure every time something is changed, even when all the inputs have not been added yet. Is it possible to run the look up only when the final input is added "(variabl...>Lot Description"
What's odd is if I do not hide the auto fill button and actually press it, everything is quick, but the lookup doesn't seem to work. None of the data that it pulls back is filled in. However, if I hide it and have it auto press, the data is returned correctly, it's just too slow to actually use.