>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
Jasper,
Try creating the view again but this time, open it with NODATA. Create the necessary index. Because there are no records, the index creation will be very fast *g*. Then requery the view. This should populate your summary field as well as provide a means of linking it to the parent table.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao