>>Hello all,
>> I have a grid show a list of record each with two numeric fields, I want to use an additional column to show the sum of that two fields on the fly. how can I do this?
>>
>>Because I don't want to define that 'sum' field on tabel structure, I have following problems:
>>-I have try use local view, but local view have no index, so I can't use it to link to parent record.
>>-I have try the assign method of that tow field to update the sum column display, but it is unreliable that all row's 'sum' column display the current record's 'sum'
>>-I have try to create a temp table which have that 'sum' field and link to my table. And set the controlsource of column 'sum' to that temp table, but it also doesn't work.
>>
>>Could you help me?
>>-Jasper
>
>With a similar problem I made an extra column with >>price*quantity<< in the ControlSource property. It works on a table with 30.000 records without problems...

Oh my God, what a fool I am, why I waste so many hours to solve this simple problem.

Thanks everyone of you, I learn a lot.

-Jasper^^