Hi, how can I work with different tables in a template?
Example I have thes three tables, one with customers, other with relations between Customers and other with Sales:
Template grow from Sales table.
In the template i need to indicate “YES” if the person is under 18 or “NO” if the person is 18 years or older. And if customer is under 18 display the data of the Customer who have tutor attribute on YES(there will be only one with this condition).
I tryed with:
<<IF:SELECT(Customers[age],[document]=[customer])<18>>“YES”<<endif>> and didn´t work.
SELECT(Customers[age],[document]=[customer]) display the age data correctly.
For the second step, if the result of condition was “YES” show the Customers data who is tutor, i´m lost.