11 Replies Latest reply on Nov 2, 2011 2:56 PM by MichaelLane

    Totalling a Portal currency field



      Totalling a Portal currency field


      My database has 2 main tables: Jobs & Stock. The tables have no common fields so I also have a Join Table to create the Relationship.

      I use the Join Table to allow me to populate a Portal (Jobs layout) in which Stock details are added to the Job.

      Is there a method to total the Currency field from the Stock table to identlify the cost of the stock items used by a job?