I’m certainly not an expert in this area, but wouldn’t your scenario be the exact kind of thing that database change triggers is designed for? If you haven’t seen this post, check it out and see what you think…
Best… Mike
