When you insert, The record pointer will Be at EOFAfter your insert, your scan will terminated and your relation will not work since your cus_acct is empty )At Eof)



>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