Hello again - I am trying to limit emails from being sent before there any records are added to a child table.
I have an Orders table (OrderID) and an OrderDetails table (OrderDetailsID), that are referenced and dereferenced by the key field.
When I create an Order there are occasions when the record needs to be updated prior to any service being performed at a customer site. My workflow routine is set to look for updates to the Order table and send out a completion of service email to the customer. I would like to limit the email sending routine to only work when there are related records to the Order in the OrderDetails table.
I have set up a condition in my workflow:
([OrderEmail] = FALSE) AND (IN([OrderID], [Related OrderDetails][OrderID]))
The OrderEmail statement is needed to stop future emails going out if the completed order is modified as it proceeds through other phases of the system at our facility.
I’m looking for a way to look at the OrderDetails table for any record with an OrderID that matches the current one.
Thank you as always.