hemant3080

You can create a year table where you can store the year as 2010,2011,2012 and so on and use the id of the year in your transaction table. When year will change u can easily start the serail number again with 1 and it will also not create any duplicacy …

Hi, Please let me know what exactly are u doing as Chris and veena are 100% correct but i didn't get how it's working for 2 forms and not working on other 2 forms.

if possible share the code