You need to sign in to do that
Don't have an account?
sriram anil
how to write trigger
id(autogenerated) name
---------------------------------------------
a-001 aaa
a-002 bbb
a-003 ccc
-------------------------------------------
the above table i am delete a002 and a003 records, again insert another record ,this time automatically start with a002
how to write trigger above program any one pls forward code
---------------------------------------------
a-001 aaa
a-002 bbb
a-003 ccc
-------------------------------------------
the above table i am delete a002 and a003 records, again insert another record ,this time automatically start with a002
how to write trigger above program any one pls forward code
Basically auto number field default is readonly ,So you can not assign value from trigger .
However you can do one thing to achieve this ,
Click on the field >Click on edit >Click on change FieldType >change to Text and then save .
Again change the field type to auto number and add starting number 2 also format as previous format .
It will help for sure .
Let ma know if it helps
Thanks
Mnaoj