Re: calculated field

[John Heinze]

I figure it out!
CREATE DEFINER = CURRENT_USER TRIGGER `ISPBG`.`tblCircuitID_BEFORE_UPDATE` BEFORE UPDATE ON `tblCircuitID` FOR EACH ROW
begin
set @vCID = (select concat_ws('-',new.CustomerIDFK,new.NodeNumIDFK,new.ONT,new.VLAN) from tblCircuitID where CustomerIDFK = old.CustomerIDFK);
set new.CID = @vCID;
end;