AnsweredAssumed Answered

Calculating Totals Between Related Tables

Question asked by wrobinson on Feb 25, 2013
Latest reply on Mar 7, 2013 by philmodjunk


Calculating Totals Between Related Tables


     Hi everyone,

     I'm trying to use the 'aggregate' function to add values from related tables, but the calculation does not seem to work. The values I am trying to add come from three separate tables, and this is what the calculation looks like from the Current Table...

     EveCredSum = Sum ( Evening_Checklists::EveningCredTotal ; Morning_Checklists::MorningCredTotal ; Afternoon_Checklists::AfternoonCredTotal )

     Also, is there a way that, when one record is created it can be automatically copied into another table? Without using the portals?