Hello everyone,
I have a form that is doing a lookup based on vendor ID matching. If the ID matches it fills in a dropdown that contains a variable for another lookup. The dropdown that gets populated is hidden until the user checks a box to show that dropdown. My issue is that even though the dropdown is hidden, my table is auto populating the results even though the user didn't say to by checking the box. Is there a way to force the BLANK option in a dropdown to stay even when doing a lookup that only contains 1 item from SQL?
Ideally, I only want the table to populate when the checkbox for "Use a GL Template" and a template is chosen, but since that dropdown gets populated with only 1 result, LF wants to just populate the data ahead of time.
Attached some screens to help assist.