I wanted to print a Ledger for an accounting system. Now the data comes from many source tables like Invoices, Purchases, Journal Vouchers, etc. and on any given detail line only one source will be required for the doc. no., dt. and particulars. The no. of source tables will have a tendency to increase/decrease, then what will be the consequences.

I had previously developed an accounting system in FPD25 and I had incorporated a system wherein all the source tables for the ledger will have to have a corresponding entry in an internal table solely for ledger reporting purpose. This internal table then at the time of reporting would related to the required table and bring in the doc. no., dt. and particulars. This had it's drawback as the records did tend to go out of sync with missing or undeleted entries in this internal table.

In terms of VFP6 what should be my strategy for ledger reporting?

Thanks in advance.