I have established a temporary relationship between 2 tables(scrental and sccust).

as I scan through scrental, the pointer in sccust moves correctly, until I put an insert...values command within the scan. Then the pointer in sccust no longer moves correctly. Here is the code: If I remove the insert command and only leave the messagebox then it works correctly.

select sccust
set order to cus_acct
select scrental
set relation to rnt_acct into sccust  && Sets relation from scrental to sccust

select scrental
scan 	
   messagebox(sccust.cus_ccno)
   insert into scautopy (aut_pk) ;
   values(padl(x3genpk("scautopy","sc"),5,"0"))
endscan

Any ideas?

Thanks,
Paul