12
If I will implement this, I wouldn’t need 3 separate tables for this.
I will have 2 tabkes with a parent child relationship.
Totals goes to table 1, payments go to table 2. The balance in table 1 will be a virtual column summing up the payments in the related table 2.
The remaining amount table will simple be a slice of table 1 since it already has the balance virtual column.
I will then display table 2 as an inline table and out a behavior that I can’t add more payments if balnce in table 1 is already zero.
The form saying “Pay Now?” Will be based in a yes/no column in table 1 but hidden from the forst forma popuo utilizing Input () function.
1 Like