Calculate data field from another table
I have an main table where i put my contrat details, such as:
End Contract Date
Type of product
This "Renew Date" depends on the number of months that i put on another table. The "Type of product" is linked to another table, where i define the "Group of Products". The number of months is writen here, by Group of Products.
So, the Renew Date is calculated on the number of months of Group of Product before the "End Contract Date".
I've tried this with Query and it works.
But i need to put this directly on the Table where i have the contracts.
There's a way to put this on Expression Builder?
Regards in advance...