Calculating Totals Between Related Tables
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?