Subitems: records inside records — Totals from subitems

A Rollup on the parent summarises its subitems. An order total is a Rollup over Order Line Items, through the link back to the order, summing the amount field. Because the rollup follows the same link the grid does, the number tracks whatever you type into the rows.