///start///

Note : Add after insert and after update

if(new.status='Pending') THEN
    update budgetdetailstbl set status=new.role where id=new.budgetfk;
    end if;