Here's my code:

select 5
use table2
set order to id

select table1
set relation to id into table2

However, in my debug window I have the variables table1.id and table2.id. After the set relation is executed, table2.id goes to blanks whereas table1 keeps the correct id. What am I doing wrong???

Thanks,
Sunshine