I don't need to link a payment to an invoice. It is about overall situation. The payments are from the total of remaining invoices/amounts unpaid for that supplier.
The reason it is to be able to have the balance for 1 supplier at a moment in time.
Is there a solution?
Hello comunity!
I have 3 tables
Table Supplier
SupplierId
Supplier
Adress
Table SupplierInvoices
InvoiceID
SupplierID
Data
SupplierInvoice
TableSupplierPayments
PaymentID
SupplierID
Data
SupplierPayments
The relations: 1 to many from Suppliers table to Payments and Invoices. Linked field...