Inserting and updating a new record in multiple tables joined by a foreign key?

Yep.