Work Flow Start Error

[Dan_Lawrie]

Hi,

Hopefully someone can help, I am trying to create a workflow email rule, but I keep getting an error message that I can not seem to figure out what its telling me, and no examples for what I am looking for.

My email should consist of the order details from a new order, so each order can have multiple rows all with their own id.

The table I have set up in my template has these details;

Column “Product Code”
<<Start:[Order Details]>><<[Product ID].[Product Code]>>
At this point I want that column to lookup all the rows with the matching order id and return the product ID

Column “Description”
As above but return the description

Column “Quantity”
As above but return the quantity

Column “Line Value”
As above but return the Value

So if one order has two lines (OrderDeatails ID) its should return two lines, if it has four its should return and so on.

Thanks in advance