2 Replies Latest reply on Aug 3, 2010 3:41 AM by yandg

    portal totals in current file



      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.