Is this an unstored calculation field or a number field with an auto-entered calculaiton?
Are you using FileMaker 13?
Please describe the design of your layouts and whether you are doing all of this in one window or two. What exactly are you doing when you "come back to the main customer tab"?
Turns out I needed a Commit Records Script step. That fixed it.
I'd never used this script step in five years of FMP so I guess I'll read up when it's needed....
Thanks as always for your reply.
I had a Customer Tab and a Jobs tab (the portal) with an "X" relationship on them so I could do a calculate regardless of the relationship. Could have used ExecuteSQL too I suppose to a variable to get the count and sum of the amounts in the portal, but didn't do it that way this time.
In any case, I added to the OnPanelSwitch of my tab control the CommitRecords Request script step and the Customer tab is up to date when I click back to it.
When I get a "won't refresh" issue, I run the following list of fixes from top to bottom:
Refresh Object (New in FMP 13)
Refresh Window [Flush Cached Join Results]
If I have to use the last option, I start re-evaluating my design as that option can lead to major delays waiting for a layout to refresh if there's a large amount of data involved.
Amazing. You should write a "tips and tricks" book for FMP.
This is great information!
Most of the current FMP books are, IMHO, way too basic ("your first script", etc.).
Well I have launched a kind of small scale series of, for lack of a better description, FileMaker Files pretending to be e-zines on FileMaker techniques:
They are free to download, but I do provide info on how to make a "donation" if you care to support future releases of the series.
Adventures in FileMaking #1 - Conditional Value Lists (includes details on how to set up a basic field based value list)
Adventures in FileMaking #2 - Enhanced Value Selection (what to do when a simple value list won't cut it.)
#3, Many to many relationships is currently "in development".
Why not instead, or in addition to, setup a web site on your domain and make a big deal out of your skill and knowledge?
You could also blog, etc..
Just an idea.