Email Credit hold notification

Vantage 8.03.408A Progress

I have run into a problem trying to set up two emails, one that would go out when an order (not the customer) goes on credit hold and another one when the order goes off credit hold.

The problem is that an order doesn't go on credit hold, the customer goes on credit hold and the order has a credit override flag. So the trigger has to be based on two differnt tables, and while that doesn't sound so hard, the variations on how all this interacts has become a nightmare from a programming point of view. To make matters worse, the two emails goes to two different groups of people.

Has anyone attempted to set something like this up? I would be gratefull for any pointers on the best approach.