My case is little complicated, but let me give simplified example to get started with.
There are three table. First two tables has relationship, parent and child. The third one is independent, not being referenced by neither of the rest of two tables.
Create workflow rule using Parent table.
By using reference function ,we are able to show the selected columns from both Parent and Child. The problem is I could not find a way to show the data from third table onto same workflow template.
Regardless of the selection of row in parent table, I wish to show all of data in table format from third table on this email template .
Is there any tips available to achieve this task?