Hi Perry

>I work a lot in accounting, and I've never seen the type of field you are talking about stored in the table. It's easy to generate. If you have proper indexes between the tables, you can create a flat file with SQL that you print the report from and it will be negligible time.

Glad to know you are doing accounting apps too. I will try to explain my current situation in more detail. For simplicity let us assume it is a customer ledger app.

The Customer Master table

iID   Integer   (PK)
cName Char(35)

The Invoice Header table

iID        Integer   (PK)
iNo        Integer   (Invoice no.)
dDt        Date      (Invoice date)
iPartyId   Integer   (FK to Customer Master table)

The Invoice Items table

iID     Integer   (PK)
iPID    Integer   (FK to Invoice Header table)
cItem   Char(35)  (simply to avoid another mater for the eg.)
bQty    Double
bRate   Double

The Payments table

iID        Integer   (PK)
iNo        Integer   (Payment no.)
dDt        Date      (Payment date)
iPartyId   Integer   (FK to Customer Master table)
bAmt       Double
mRemarks   Memo      (This is appended to the generated mNarration below)

The Accounts Ledger Table

iID         Integer   (PK)
iPID        Integer   (FK to either Invoice Header or Payments table)
iPartyId    Integer   (FK to Customer Master table)
bDebitAmt   Double
bCreditAmt  Double
mNarration  Memo

The mNarration will contain the text I mentioned previously. A record each is generate for Debits and Credits. This Accounts Ledger table is currently the one I am using to print the ledger pages utilizing the stored mNarrations.

I would like to completely avoid this last table. Like you mentioned that it is easy to generate, but my main concern is creating the mNarration text at the time of creating the flat cursor.

Please advise.

Thanks.