Subject i want to update datas of parametric tablename in trigger
Author orhanturhan
for example

CREATE OR ALTER TRIGGER CUST_BU0 FOR CUST
ACTIVE BEFORE UPDATE POSITION 0
AS
....
begin
.....

if(new.type=1)then
update account1 set balance=balance+new.total;
else
if(new.type=2)then
update account2 set balance=balance+new.total;
.....
end

my cust table type values are increment.
my account tables are increment and user create on runtime in my software (account1, account2...accountN).
i dont want to if else if else if else ..... it is wrong method.