Search results

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?

I reattach the picture with the final result because when I write it I lost the order!

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

Hi, I am Cristian. I am a new member! Here to learn!