Hello mates, I
ve spent hours trying to display a simple table on an e-mail body triggered by a new record in a table, but Im really lost here. Let me try to explain and see if you guys can help me…
Basically I have a table called ‘MaterialRequest’ (key = requestOrder) which columns are shown attached.
for each order I can have multiples materials to be ordered with, They are on the table ‘MaterialOrderDetail’ (key = orderId).
I have the virtual column [Related MaterialOrderDetails] (REF_ROWS(“MaterialOrderDetail”, “requestOrder”)) which yields all the orderId for each requestedOrder.
All I need is to find a way to include into the e-mail body template, for each new order, all the materials, quantity and measurements (from MaterialOrderDetail table) on a table.
The way I`m doing that without any result is below:
Thanks in advance guys