Trigger:
INSERT INTO payments SET identrada = NEW.id, idusuario = NEW.idusuario, idcuenta = NEW.idcuenta, payment = 0, description = 'Entrada', sinpagar = 0, form = 'S / P', time = NEW.hour, date = NEW.date, postdate = NEW.date
My entry table:
My payments table:
My mistake:
Can not add or update a child row: a foreign key constraint fails (
munici27_proHASS
.pagos
, CONSTRAINTpagos_ibfk_1
FOREIGN KEY (identrada
) REFERENCESentrada
(id
) ON UPDATE CASCADE)