Hi I need help of creating a trigger. I have 2 tables those are
I need to create trigger that resulting unique number on transaction file. Both table is related on Transaction.Div = Division.ID. The scenario is after the transaction saved on transaction table, the trans.id will save the Rnum value and the Rnum on Division will added 1 and so on.