I guess I misunderstood you, I am keeping track of the payment info, but have it in the same parent table. The question was why it would be better to keep the payment info in a second child table?
>Oh, OK.
>
>For audit purposes, I would consider tracking the payments date, amount, and invoice applied to in a separate table.
>
>
>>Hi John,
>>
>>In this app I'm simply applying the payment torwards the balance.
Tony
Skill comes from Diligence