thank you for reply
i add for the 2 tables field id and your code it works
but i need to run it as below
clea
CLOSE all
USE table1 IN 0
SCAN
m.tot=inctax+addtax
m.penttot=penttot
USE test IN 0
IF nam="tot1"
SUM y2010 TO m.q
REPLACE y2010 WITH m.q FOR nam="tot1"
else
replace test.y2010 WITH m.tot
REPLACE test.column6 WITH m.penttot
endif
IF nam="tot2"
SUM y2010 TO m.q
REPLACE y2010 WITH m.q FOR nam="tot2"
else
replace test.y2010 WITH m.tot
REPLACE test.column6 WITH m.penttot
endif
IF nam="tot3"
SUM y2010 TO m.q
REPLACE test.y2010 WITH m.q FOR nam="tot3"
m.total=tot1+tot2+tot3
REPLACE test.total WITH m.total
else
replace test.y2010 WITH m.tot
REPLACE test.column6 WITH m.penttot
endif
endscan
thanks
>>hi all,
>>
>>i need help to get next value from table1 via this code below
>>
>>
>>USE table1
>> m.tot=inctax+addtax
>> m.penttot=penttot
>>
>>USE test
>>Select test
>>SCAN
>> replace y2010 with m.tot
>> replace column6 with m.penttot
>>
>>**USE table1
>>
>>ENDSCAN
>>
>>thanks
>
>How these two tables (Test and Table1) are related?
>
>May be you can do just one update command, e.g.
>
>UPDATE Test Set y2010 = T.incTax + T.AddTax, ;
> Column6 = T.PentTot
> from Test inner join Table1 T on Test.ID = T.ID