AnsweredAssumed Answered

Get(ActiveFieldContents) - To get a summary field total results

Question asked by JoaoNascimento on Apr 26, 2012
Latest reply on Apr 27, 2012 by JoaoNascimento

Title

Get(ActiveFieldContents) - To get a summary field total results

Post

Hello everyone,

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:
ValueTable::TotalValue*Field1/1000

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?
Thanks

Outcomes