Displaying / Using the result of a calculated field in a field in another table
I have three tables: Customers --<Invoices --<Line Items
I would like to add a field in a Customers table that would display the content of the Balance Forward field which is a summary field in the Line Items table.
If I create a calculated field Customers::c_Balance Forward =Line Items::c_Balance Forward I get the sum of all the Balance Forwards accros all of the customer's Invoices. How do I get the caculation to "look" at the latest customer's invoice/line items only?
I am probabbly doing this backwards but would really like to be able to flag / filter customers with balance forward and wil very much appreciate any sugestions you may have.