First of all, thanks for this amazing tool.
I wonder if somebody has used the SQL Expressions.
In my model I have two tables one for:
So, it can be multiple records for Detail for every Header. The amount total in Header will be the sum(Subtotal) in Detail for every po_nbr.
So I'm trying to use in SQL Expression:
In table PurchaseOrder_Header, field ph_amount_total
Select sum(pd_subtotal) FROM PurchaseOrder_Detail where pd_po_nbr=:ph_po_nbr
I even try to make a Simple Select as:
Select ph_vendor_nbr FROM PurchaseOrder_Detail where pd_po_nbr=:ph_po_nbr
And all the possible variants to this without succeeding.
If somebody could guide me, it would be appreciated.
Thanks in advance,