What I want is that code1 and code2 in the transaction
table hold the last number of their master table.

I have to execute 2 updates and 1 insert, but How do i pass
the last value of each master table to the insert command ?

c.x.