Tom,
The easiest way is to write a SELECT with whatever calculations and transformations that you need. Make sure to specify the destination field names if they will be different.
select field1, field2, field3+field4 as newfieldname ;
from table1 into cursor tmpcursor
select table2
append from dbf('querycursor')
- Keith
>This is so simple i am missing something.
>I have a table A it has say 20 fields.
>I want to append all the records to another table B just not all the fields,
>and one field i need to make from two on the original table. A.zip + A.zip_4 to B.zip.
>Table B is a less field version of Table A, with the exception of the zip fields above.
>
>I have tried scan .. endscan do.. enddo
>with a scatter memvar
>then use B
>append blank
>then gather fields M.field1, M.field2, etc..
>skip
>
>This is not working.
>Is there a simpler way to do this?
>
>Thank you.