Mohammed,
you clearly like to show us your code which does not work. I think this is not a good idea. Instead I suggest that you tell us WHAT you want to do, then we can tell you how it should be done.
>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