Adversity is the key to innovation and broadening your world...

While you may not directly insert  to targets with Foreign Keys, you can use a temp/variable table as an intermediary and then migrate to the FK inflected target