inserting into multiple tables
thank you for getting back to me. I will do that. My concern is that I am using the userID as the primary key in the user table, which will be automatically generated by MySQL on the creation of the record, and need to insert it into the foreign key of the address table.
How do I first create the userID key and then insert it into the address table as a foreign key in the same operation.