1 Reply Latest reply on Dec 20, 2010 3:03 PM by philmodjunk

    Summary Field

    jd3

      Title

      Summary Field

      Post

      Thanks to all who have offerd to help! Still having an issue on what seems to be a very basic and simple fix.

       

      In Browse Mode, I have a Layout which I view in table view of many items that are sold. Each record has the name of the product in one field and the number those products sold in another field. (Simple Excel type of data: column A = item, column B = count of those items sold. I created a summary field to give me a total of all items sold, which returns the correct number. The problem comes when I change the number of a product sold to a different number, the summary does not recalculate my totals. If I go back to the manage database section and tell the field name that it is a summary field, it will then calculate the correct number, but again, if or when I need to change one of the records, the summary does not recalculate....

        • 1. Re: Summary Field
          philmodjunk

          WHere is the summary field displayed? in the header, footer or a column in the table?

          You shouldn't have to redefine the field just to get it to update. You may have to click out of the field and click an empty part of the layout to commit the changed value so that the summary field can effectively recalculate the new total.

          A script trigger set on the quantity field could be used to use Commit Record to force the field to update when you exit this field if it is really needed.