portal totals in current file
Have searched for this and cant seem to find any similar posts.
I have a table eg inventory and another table sold
I have a portal of the inventory in the sold file showing items linked by sold_id and i would like to show the total cost of the items showing in the portal.
So inventory::sold_id = sold::sold_id - All relevent records show in the portal
But i cant get the field Sold::total to show the sum of inventory::price it shows all the prices on the inventory file and not just those with the sold_id that matches.
Any pointers appreciated.