AnsweredAssumed Answered

portal totals in current file

Question asked by yandg on Aug 3, 2010
Latest reply on Aug 3, 2010 by yandg


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.