Automatically Update Summary and Calculation Fields

[dtsparky]

I have summary and calculation fields that are on a layout that is in a different table than the summary and calculation fields are for. They work OK with the exception that you have to click in them to get them to update when information that they summarize or calculate is changed. Is there any way to make these fields update automatically when any of the fields that they summarize or calculate from are changed?

Thanks

[Søren Dyhr]

When dealing with summarization over a relation, is it usually the aggregate calc' function Sum( which is utilized ... a genuine Summary field from a relation away exhibit exactly the behaviour you descripe here.

Please explain why it has to be the genuine, in your case?

A straight forward example is this:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

Where you can study when to use which and why, the genuine is here used for prinouts only.

--sd

[dtsparky]

Thank you

Your solution worked perfectly. I really appreciate your help.

[R2D2]

Hi !

This is a newbie question, but I just cannot figure out how I can get this updated total over the relation.

I have a table "Main Stock" which shows itmes in a list and Main store situation (for example 20 pens in stock) and it related to an other table ("Loans") via item number. If a person takes a product to loan, it is added to the Loans table (for example 5 pens) as a record. If another person also loans 8 pens, this should be updated to the "Main Stock" -file via relation (in this case 20-1-5=14).

I'm confused with these summaries...

EDIT// Problem solved - wrong field in calculation... :B