I have a number of records based on Table 1. On each record there is a field, Field 1, which is a Calculation Field, containing a value.
On Table 2 I want to add all values from Field 1 and put the new value into Field 2, another Calculation Field.
The two tables are related with a foreign key on Table 2 linking to a primary key on Table 1.
What would the Script for Field 2 look like?