There is no way to do this simply.
This is a bad design.
To enable this, you will have to drop the foreign keys, do the insert (s) then recreate the foreign keys WITH(CHECK)
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”