Summary VS Calculation field

[Anthony Nelson]

I have tried with both types and am unable to get the results I really want. I have a table that has a quantity field. I want to display a total of the field. I have tried both using a summary field and also creating a self relationship to the table and Sum( relatedField ) but both seem to not update until I click on the field. I would like the field to show the total as soon as any of the other items get changed.

Any one have any suggestions or know what I'm doing wrong?

[-Queue-]

Do you want the total for all records in the table or only for the currently found set?

[Anthony Nelson]

Totals for all

[-Queue-]

Create a self-relationship based on your serial and use X as the join operator. This will relate every record in the table to every record in the table. Then just create a calculation of Evaluate( "Sum(yourrelationship::quantity)"; quantity ).

[-Queue-]

I failed to mention that the calculation should be set as a global also.

[Anthony Nelson]

Thanks, I had everything setup except the evaluate function. I didn't really know what it did so I didn't look at that one

[-Queue-]

You could just use Sum(relationship::quantity), but as you noticed, it doesn't update immediately. Using the Evaluate function forces it to update whenever the quantity field is changed.