Hi,

I've recently been getting my head around workflows, and have set up some pretty useful processes with the help of posts here at Sage City, but unfortunately this particular request is giving me problems.

I need to set up a process whereby if a customer is placed on hold, the system searches for any existing open orders this customer has and update their status to Held also.

I can create a workflow to trigger when a customer is placed on hold, and I have created an update transaction that will search for and update the held status of orders (with a customer number as a parameter), but I'm not sure how I can link these to fire the update transaction from the workflow, or, if I can, how to pass the customer number over as a parameter.

Is this possible?  If not, is there another way I can go about this?  Thanks!