Hi - I'm having a problem I've seen posted elsewhere but none of the solutions suggested seem to do it for me.

I have a list view with summary fields in a trailing grand summary (Simple Total of type summaries).

They start out correctly. However, after a script goes through and makes changes to the records in the list, the summary fields do not update. A calculated field which is on this layout but comes from a different table and is the same as one of the summary fields DOES update after the script runs.

Changing modes does not help. (ie preview and back).

Clicking on background of layout does not help.

Adding "commit record" steps in script after each group of "Set Fields" also does not help. Nor does a refresh window step at the end of the script.

However, doing a new find to regenerate the list DOES update the summary fields - but this is undesirable because I want the user to see the changes made to the fields by the script and once I update the found set, the changed records are no longer in the found set (because a Balance field goes to zero).

I was sure it was a commit record issue but does not seem to be - any suggestions?

Thanks,

Michael

Try "Show Omitted Only" then "Show Omitted Only" to refresh the found set, I had same problem and this worked for me.

If a Summary field is located outside the header or footer area, can't they freshen ...but when a dependency of a value from a relation away is involved must the field be turned a calc'field via:

http://www.filemaker.com/help/FunctionsRef-341.html

But we can't from what you write see if you instead really need to do the task with an aggregatefunction over the relation, perhaps even a recursive relation. Further do we not know if you field a relation away depends on a global field - perhaps placed in a table where it can't force the freshing thru ...all these are required infos to improve your solution.

--sd

They start out correctly. However, after a script goes through and makes changes to the records in the list, the summary fields do not update. A calculated field which is on this layout but comes from a different table and is the same as one of the summary fields DOES update after the script runs.

I began to think that this has similarities with this thead, correct me if I'm wrong:

http://www.fmforums.com/forum/showtopic.php?tid/184579/post/240589/#240589

--sd