I know I’ve read about this (a while ago) and I’m sure it’s possible. I don’t have time to read through every post and try different search criteria to find the answer, so I’ll just ask.
Is it possible to trigger a group when a value in the database changes? I can’t seem to figure it out. I think my head is buried too deep in this project and after I walk away for the night I’ll probably remember.
When an operator scans a batch number off their batch paperwork, FactorySQL checks to make sure it’s an approved batch number, and if it was checked as DONE the last time it was shut down. It then sets two bits high or low depending on what it found on the SQL server. If an operator needs to re-process a batch that had been marked as DONE, a supervisor can open an Access database file, find the bath number, and un-check DONE. Upon seeing that change I’d like FactorySQL to write a 0 to that bit (This is a different group than the one that runs when a new batch number is scanned.)
I just can’t make it work right. I’ll think I’ve got it working, then realize it’s not correct. Now I’m so lost it just keeps oscillating that bit high and low every second.