That would work for a single user scenario...
But what happens when multiple users are doing the same thing almost simultaneously???

The wrong foreign key values will be inserted to Table 2 with disastrous effects