The simplest way is normally to update the related (foreign key) tables, making certain that the values exists before attempting the insert / update of the other tables which have foreign key constraints.

😎