How can I insert a new record in Phoenix/Ecto and update the foreign key in another Schema?

There are probably a few different ways to achieve this but I would strongly suggest using Multi to keep things more explicit.