Autofill intermediate tables

[Mase5701]

Is there a built-in way to auto fill an intermediate table with numeric values so it equals the sum of a value entered into a primary table?

My goal here is an order payments system that pays orders on a FIFO basis.

I want to fill tblPayments and have the PaymentAmt then automatically split up into the OrderPayments starting with the earliest OrderDate (I want to add manual controls in later


tblOrdersT ----- tblOrderPayments ----- tblPayments
OrderID PaymentID PaymentID
OrderAmt OrderID PaymentAmt
OrderDate amtApplied

I think I almost have it done but I have a mess of if then macros and action queries, and it seems like I'm going a very round and about way to do what is a simple built-in function.

Thanks.

 

[xenou]

Hi,
I don't believe there is any built in feature that would accomplish this.