Managing Summary Columns
When two tables are related, you can create summary columns. Summary columns are columns in a master table used to represent calculation of specific data from a detail table. For example, the
Invoices table displays the total amount for all invoice items stored in the
As a result, the
Total summary column calculating total items amount will be added to the
To add a summary column to the related table:
Setup link in the top right corner of the window
Select a table you need.
From the setup menu select
Relations form click the
Add Summary button next to a necessary relation.
Summary column form will be displayed: