Serial # Question

[Ron F]

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

[LiveOak]

What exactly do you mean by "reset" the case number?

-bd

[Sxeptomaniac]

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

[Ron F]

reset meaning at the begining of the new yeat (12am- Jan. 1, 2006 for example). the serial counter goes to 06-0001.