INSERT INTO vs. LASTMODIFIED - can u beat it?

[BrandonSk]

So, I have two tables. One has a Unique Identifier of records. Once I add a new record to that table I use the identifier in the other table to link those records together. In the code I first add a new record to the 1st table and then to the 2nd one. It is easy to get the Identifier value using the AddNew method and then moving to the new record through setting the Bookmark to the LastModified property. BUT when I use "INSERT INTO ..." sql statement to add a record to the 1st table the LastModified property is not set. So the question is HOW CAN I REFER TO THE NEW RECORD made through the INSERT INTO statement?
Thanx for help everybody.