Re: Many to Many? Maybe Not

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On May 17, 12:19 am, Ed Murphy <emurph...@xxxxxxxxxxxx> wrote:
B. Edwards wrote:
tblPayments
Payment_Amount
Payment_Id

tblTransactions
Account
Transaction_Amount
Transaction_Id

tblTransactionsPayments
TransactionId
PaymentID
PaymentAppliedAmount

Well, yes, but can that last table be populated without cursors?


tblTransactionsPayments
TransactionId
PaymentID
PaymentAppliedAmount

This seems to address that. I see that if there is a payment amount
left over that a new record would be inserted with the same ID's but
with the remaining amount. I am looking for a way to do this without
using cursors but I am running out of options.


.