It sounds like the data is being loaded correctly in the SQL worker, but the remote form isn’t triggering a refresh/redraw until you switch tabs, which usually points to a client-side refresh or server call not being fired after the data update.
It sounds like the SQL worker is updating the list data correctly, but the remote form is not being refreshed automatically after the worker finishes. Have you tried forcing a redraw with $redraw() or calling $sendall() after the worker callback completes?
Also, are the lists inside a subform or a complex grid component? Sometimes remote forms need an explicit client refresh when data is populated asynchronously.
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.