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