I have simple form that populates two form tables from two sql queries after a user inputs their username. For the most part the form works fine however sometimes the 2nd table can be seen to populate with the correct query data and then the data disappears leaving only the form header ‘Available Groups’ displayed.
This is an intermittent issue, most of the time both tables load and display. The only time I see it occur is when the form is first displayed and the first username is entered. Entering other usernames after the form is loaded, including the original name, always works. Again, before the 2nd table disappears it does populate with the correct query data and then it just disappears.
Between the two database queries only 4 rows of data will ever be returned. I tried putting a 2 second delay in the 2nd query but the issue persists.
Is there any way to fix this????
Thanks