A foreign record insert occurs when an import makes a change to a table that is not the target table for that import. This happens when updating a reference field on a table.