B. Edwards wrote:

> tblPayments
> Payment_Amount
> Payment_Id
>
> tblTransactions
> Account
> Transaction_Amount
> Transaction_Id
>
> tblTransactionsPayments
> TransactionId
> PaymentID
> PaymentAppliedAmount

<strvariant@yahoo.com> wrote in message
news:1179340212.080361.161490@p77g2000hsh.googlegroups.com...
>I have two tables. One for Payments and one for Transactions The
> tables are set up basically like this
>
> Payments
>
> Account Payment_Amount PaymentID
> 1234 $100.00 1000
> 1234 $100.00 1001
> 1234 $100.00 1002
>
>
> Transactions
>
> Account Transaction_Amount TransactionID
> 1234 125.00 9999
> 1234 125.00 9998
> 1234 125.00 9997
>
> There are no common fields, in either table, other than the Account
> number. The payments have to be applied to the transactions until the
> payments are exhausted.
>
> The trick here is that when the first payment is applied to the first
> transaction there is $25.00 remaining. When this happens the second
> payment is applied to the remaining $25.00 first and then to the
> second transaction. In this example the second transaction has a
> remaining amount of $50.00 which will be used by the third payment and
> so on.
>
> This is the end result --- that all of the payments are applied to the
> transactions. But you have to be able to tell which payment (or
> portion thereof) was applied to which transaction. Any ideas?
>
> Thanks,
>
> strvariant
>

On May 17, 12:19 am, Ed Murphy <emurph...@socal.rr.com> 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?

On May 17, 10:54 am, strvari...@yahoo.com wrote:
> On May 17, 12:19 am, Ed Murphy <emurph...@socal.rr.com> 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.- Hide quoted text -
>
> - Show quoted text -