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&&not work
>>
>>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