CREATE TRIGGER `nacllog_after_ins_tr` AFTER INSERT ON `nacllog`
  FOR EACH ROW
BEGIN
  UPDATE
    `repairs` r
  SET
    r.`NOOFNACL` = (SELECT COUNT(ID) FROM `nacllog` WHERE `JOB_NO` = NEW.`JOB_NO`)
  WHERE
    r.`JOB_NO` = NEW.`JOB_NO`;
END;