I am using Paradox 8 to track payments from debtors. I use a form from 2 tables. The parent table has fields
ersonal inf. & BegBal, TotPd & Curr Bal. The child table has fields: Date Pd. & Amt Pd. On the form, Amt Pd is defined as "sum of Amt Pd" and Curr Bal is defined as a calc. of BegBal-SumAmtPd. This works ok, except when I need a query of files with CurrBal. The query is ran on the table & the field is blank in the table. How can I update the field in the table?
ersonal inf. & BegBal, TotPd & Curr Bal. The child table has fields: Date Pd. & Amt Pd. On the form, Amt Pd is defined as "sum of Amt Pd" and Curr Bal is defined as a calc. of BegBal-SumAmtPd. This works ok, except when I need a query of files with CurrBal. The query is ran on the table & the field is blank in the table. How can I update the field in the table?