Sunshine,

After a SET RELATION you nmust move the record pointer in the source table before the relation takes effect;

select 5
use table2
set order to id

select table1
set relation to id into table2
LOCATE && move record pointer to the curretn record

If after this change table2 still shows a blank Id it is because of what Sebastian has told you.