May 5, 200520 yr I have a text field that keeps a sequential case number that is incremented by one for each new record (i.e. 05-00001). My question is this...Is there a way to have that sequential number reset (06-0001)at the begining of each year. i have done this via script and it works fine in house however I have some users that connect via wireless CDMA (1XRTT) and at times due to a sometimes slow wireless connection cause the script to reset the case number when it shouldnt. That is why I would prefer to have the field reset without using a script. Any suggestions? Thanks, Ron
May 5, 200520 yr This is an issue I've worked with as well. Try the thread below and see if it answers your questions. http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=140217
May 5, 200520 yr Author reset meaning at the begining of the new yeat (12am- Jan. 1, 2006 for example). the serial counter goes to 06-0001.
Create an account or sign in to comment