frnmj

3 years agoQrew Member

Solved

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

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 t...

- 3 years agoNo 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

------------------------------