Calc not updating imemdiately when adding new item to a Portal
I have three tables named "Invoices", "Invoice Like Items" and "Discounts".
I am in a Layout based off of the table "Invoices" and can add records to "Invoice Like Items" through a portal. One of the keyfields in the portal is a popup Menu to select a record from "Discounts" through a ID relationship .
I have a calc field located in the "Invoice Line Items" table that is set to recalculate as needed and references the Discounts table through the relationship established above.
The problem I am having is that the calc field wont update immediately. I have to click somewhere in the portal record for the calc to update.
Im sure I am missing something silly. If anyone has any ideas I would love to hear them.
"Clicking somewhere" is likely committing the record which needs to happen before your calc updates.