Get(ActiveFieldContents) - To get a summary field total results
I have a table where i add the next fields:
- RecordID (Number - Auto-enter)
- Description (Text)
- Value (Number)
- TotalValue (Summary)
After finish the value input i created the TotalValue as a Summary Field to give me the total of all the values.
Until here everything went ok.
Now i have a different table with customers information. On this second table i want to retrieve the TotalValue from the first table.
I've already tried this Get(ActiveFieldContents) but with no result.
In the Costumers information table, i'm trying to do a calculation on a single field between the TotalValue and another field from the Costumers Information table:
I've alredy done the relationship with the two tables but even so i cant receive the result i'm after.
Can you help me please?