I might have tunnel-vision on this, so if there is a better way, please advise.

In the project i am working on there is one table for all cash flows - scheduled payments (usually 60) Payments made (hopefully the same), and there can be misc charges and payments, like an early buyout for them.

It might be possible that one day they might be carrying a number of accounts that they need to, well, account for on their books, but right now there are only two. Nonetheless, i'd rather plan for the possibility than them ask me to fix it requiring a whole new approach, so... Am i better using the entire table, filtered by an order number for this, or to use a recordset? Though having watched a video by Mr. Rost on record sets, that combined with a couple videos where he used them were my first and only exposure to them. I believe that any change made to a recordset is reflected in the originating table, correct?

In displaying each entry, a payment due, a payment made, ..., in a continuous form, in the same manner that certain totals per record were displayed, does anyone know of a means to calculate/show a running total for that column in a calculated field? So if records 1 through 3 showed a payment due of 200 each, record one would show 200, two would show 400 and three would show 600?

Thank you folks. Hope one day to retain enough to be able to help others at this-