Hi Kevin,

There are 4 one->menu processing scenarious that I know about
that you could utilize to do the job;

Open&Relate Tables
*
1.
Select table1
Scan
*
Select table2
scan while keyvalue1=keyvalue2
*
endscan
skip-1
select table1
endscan
(fast)

2.
Select table1
Scan
Select table2
scan for keyvalue1=keyvalue2 REST
*
*
endscan
select table1
endscan
(slower)

3.
select table1
Set skip to TABLE2 &&one to menu
scan
*
select table2
*
select table1
endscan
(fast)

4. SQL Select

PS This what are you trying to do is little bit strange
because even if you scatter content of table1 and then loop menu side to scatter content of related records, in table 2 you will have only
last found record scattered. What about the rest?
In this case your Insert statement has to be in the inner scan
in order to get all records done.

I hope this will help you resolve your problem.
Regards

!!! How you people get to insert code section (white&indented) inside reply???

*