This content has been marked as final. Show 4 replies
try Pre-Update / Post-Update trigger...1 person found this helpful
Basically you want to update account no field based on sub acoutn no. In this case Make trigger when -validate item on sub-account no field. And write your update statement to have clear execution.1 person found this helpful
account no sub account no fields a fields b fields c
1010 00 x y z
1010 10 x y z
Sounds like wrong database design. You should split the table into two tables.1 person found this helpful
Thanks for your help. I will need to rethink the strategy.