I have customers sign in, in the lobby (3 computers), for assistance.
I have two computers, used by technicians, to call customers for assistance. Once the customer is served, a technician clicks a "Finished" icon, which clears the customer from the queue (Technician 1's computer).
The problem is the customer is not cleared from the computer of the other technician (Technician 2's computer).
To fix this issue. I ran a requery on a timer. Yes, this works; however, if the technician is adding a customer or editing a record, the requery disrupts what they're working on.
What's a possible solution? Any help would be appreciated.