>I just read that again after I posted. :)
>
>Are you saying that I should store the current and past balances in every detail record? That's something I hadn't thought of. (Mulling over the possibilities...)
>
Michelle,

NO! I am saying you should calculate the balance whenever you need it.