Hi I need help of creating a trigger. I have 2 tables those are
-
Division
ID Rnum
01 001
02 001 -
Transaction
Div Trans.ID
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.
Thx