Hi, Sunshine!

>>
After the set relation is executed, table2.id goes to blanks whereas table1 keeps the correct id.
<<

Sounds like the first record of table1 contains an id which are not matched the any index value in table 2!