I have INVOICES table and InvoicePayments table.
In INVOICES table, I have these fields:
InvoiceID, InvoiceNo, InvoiceDate, InvoiceAmount.
Currently I enter InvoiceAmount manually, but now I want to automate the InvoiceAmount field
I can calculate the Invoice Total of any Customer using a Query but I can not put that value to InvoiceAmount field.
Need some help.