Fórum FK no MySql 5.0 #373633

Cannot add or update a child row: a foreign key constraint fails (´bd_educacao´.´tb_cargo´, CONSTRAINT ´FK_tb_cargo´ FOREIGN KEY (´cargo_cod´) REFERENCES ´tb_faltas´ (´falt_cod_cargo´))

CREATE TABLE ´tb_cargo´ (
  ´cargo_cod´ int(11) NOT NULL AUTO_INCREMENT,
  ´cargo_descricao´ varchar(100) NOT NULL,
  PRIMARY KEY (´cargo_cod´),
  CONSTRAINT ´FK_tb_cargo´ FOREIGN KEY (´cargo_cod´) REFERENCES ´tb_faltas´ (´falt_cod_cargo´),
  CONSTRAINT ´FK_tb_cargo_mapa´ FOREIGN KEY (´cargo_cod´) REFERENCES ´tb_mapa_faltas´ (´mapa_cod_cargo´),
  CONSTRAINT ´FK_tb_cargo_reposicao´ FOREIGN KEY (´cargo_cod´) REFERENCES ´tb_reposicao´ (´reposicao_cod_cargo´),
  CONSTRAINT ´FK_tb_cargo_servidor´ FOREIGN KEY (´cargo_cod´) REFERENCES ´tb_servidor´ (´servidor_cod_cargo´)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC