Paul,
What happens if you make sure your SCRental table is selected - and perhaps even add code to move the record pointer (this usually 'resets' the relation)
Use the debugger to check what table is SELECTed and if your relation is still set correctly after the INSERT code.
Finally, you may want to remove the SET RELATION and use a SEEK on the SC_Cust table inside the SCAN/ENDSCAN. This would be my preferred way of handling the situation, as I've found relations to be flaky.
HTH
Barbara
>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
>
>select scrental
>scan
> messagebox(sccust.cus_ccno)
> insert into scautopy (aut_pk) ;
> values(padl(x3genpk("scautopy","sc"),5,"0"))
>endscan
>
>
>Any ideas?
>
>Thanks,
>Paul