急!应该用什么实现?
关于一个工资表TabGZ,有字段:fldGZ_date(日期),fldEmp_ID(人员编号),fldJBF(加班费),fldYCF(延长费),fldXYF(效益费),fldZE(总额),fldYLBX(养老保险),fldSFGZ(实发工资).
总额: fldZE=fldJBF+fldYCF+fldXYF
实发工资: fldSFGZ=fldZE-fldYLBX
if(fldZE<880) fldYLBX=0
if(fldZE>880 and fldZE<1380) fldYLBX=fldZE*0.1
if(fldZE>1380) fldYLBX=fldZE*0.15
当fldJBF(加班费),fldYCF(延长费),fldXYF(效益费)被更改时 fldZE(总额),fldYLBX(养老保险),fldSFGZ(实发工资)也得相应更改?应该用什么实现
(最好是触发器)