I have an database that we use to capture Orders and Payments.
When on the Orders layout the field Sum_Balance_Payment keeps on summarizing.
This field is not even on this layout.
This is a new Database with only 2300 orders, this database will grow quickly. Just worried that this field will cause issues.
Is there a way that I can fill in the Value of this field only when i go to a list view of all Paid Orders?