>Hi
>
>My client want's a table with income / expense / balance columns.
>Each row, the user will be able to insert OR income amount OR expense amount, and the readonly balance column will show the total balance in each row.
>
>My clieant plan to use with small list (few hundreds), so I prefere to forgive on the balance column and to manipulate it manually by grid/report.
use dbf("YourCursor") again alias crsTotal in 0
select crsTotal
nTotal=0
scan
nTotal=nTotal+Credit-Debit
replace totalcolumn with nTotal
endscan
use