>Dear Experts
>
>I have two tables, table1 and table2
>
>How to scatter table1?
>and then how to gather into table2?
>
>For example
>

>Select table1
>scatter && please correct this line
>select table2
>gather && please also correct this line
>

>
>I do not want to use this command
>select table2
>append from table1
>
>Please help


We are assumming that the tables structures are the same, at least most fields are shared between them.

One way would be:

Select Table1
*Seek OneRecord
Scatter Memvar
Select Table2
Append Blank  && assuming you want a new record
Gather Memvar

or probably better:

Insert Into Table2 From Memvar

or you could Scatter to an object:

Scatter Name oRecord

Then you can manipulate object oRecord and gather from it, etc.

HTH