I am using FMP v5.5 in Windows XP pro. How do I calculate the sum of a column everytime a user enters a change anywhere in that column? The layout is in browse mode and I am using a Trailing Grand Summary field.
If I click on the Trailing field or enter Preview mode, the calculation happens. But I would like the layout to behave like a spreadsheet where all totals change when any item is changed.
