You can do it in several ways :
-scatter memvar memo
insert into other table from memvar
-scatter name oRecord memo
select OtherTable
append blank
gather name oRecord
-append from SomeTable for Criteria
etc
Tekin