September 22, 200421 yr I defined a field (depositamt) in a table to sum one of two fields in related records dependant on the contents of a global field (deposittype). The field definition looks like this: depositamt | Calculation | =Case ( deposittype = "Draw"; sum ( accounts::drawamt ); deposittype = "Distribution"; sum ( accounts::distamt ) ) I also have a summary field defined as: deposittotal | Summary | =Total of depositamt When I enter an amount to either accounts::drawamt or accounts::distamt via a portal the summary field does not update unless I place the cursor in the global field and then press the enter key. Oddly enough, the summary field was updating fine when I first began the build. At some point after adding dozens of fields for other purposes this behavior started. Any clues as to what I might have done.
Create an account or sign in to comment