Good Day Experts!
I have an idea to achieve the end result but need some help.
We need to know when there are overrides performed on our system by DataEntry. When an override is performed, 3 fields are updated in a table.
I thought to do the following:
1)Put an update Trigger on that table and insert a record in a staging table with the data
from those 3 fields
2)Give the 2 Supervisors a console application to monitor these records
3)Somehow figure out when the console application is open to have it automatically
refresh the DataGrid each time a new staging table record is inserted
Can you offer any advice how to get this automatic refresh to work? Or, perhaps offer an alternative?