AnsweredAssumed Answered

Displaying / Using the result of a calculated field in a field in another table

Question asked by Kat11_1 on Jan 20, 2012
Latest reply on Jan 20, 2012 by Kat11_1

Title

Displaying / Using the result of a calculated field in a field in another table

Post

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.

 

Thank you

 

Outcomes