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?

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

Totals for all

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 ).

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

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

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.