How to update field value that's in a different table?

Question

I have 2 tables (Invoice and Payments table) which has a one-to-many relationship.
The Invoice table has an Invoice Amount field, and the Payments table has an Amount Paid field. Basically, I want the Amount Paid to be deducted from the Invoice Amount automatically once the Payment record is added.

------------------------------
frnmj
------------------------------

MarkShnierYou · Accepted Answer

No Problem.On the relationship create a summary field which is Total Amount Paid.Now the Invoice has the Invoice Amount and the total Paid.  Create a new field called balance owing which is a formula field and do the subtraction there by formula.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community