This is my problem:
Table Invoice:
InvoiceId
CustomerID
Total_Invioce (Double)
Table Payments:
PaymentId
PaymentType
...
So, one payment can distributed in more than one invoice, and payments might be partial.
I created a table InvoiceVsPayment:
InvoiceID
PaymentID
PaymentPart: stores the...