I have a solution with 2 tables: An Invoices table containing invoice information (date, amount, etc.) A Payments table containing payment information (amount, method, date, etc.) I want to link these tables so payments can be applied to invoices. I need a column that shows the remaining balance of each invoice after full or partial payments are applied. I created this using a lookup field and formula field in the Invoices table. However, I'm having trouble when I need to apply one payment across multiple invoices (either to the same vendor or different vendors). Currently, the lookup field calculates the full payment amount towards each invoice, which is incorrect. Is there a way to split a single payment across several invoices, allowing me to specify how much of the payment should be applied to each invoice? I need the final balances to correctly reflect the payments for each invoice.
