I want to insert data into 6 tables. One of those tables has a primary key field that auto-increments (let's call it ID). The other tables use that ID number as a foriegn key.
My question is, how do I know what the newly generated value of ID is in order to use it in the other tables? Do I have to insert into the first table then read back the value of ID?