my goal is to make script that creates a new

job number(record) which is made up of the following information...

month, year, then a rolling number starting at 001.

I'd like the rolling number to begin 001 on the first of

every month and reset back to 001 on the first day of the

next month. so if it started today, my number would be

111001. If we did 200 jobs this month, then my job numbers

for January would be 111001 - 111200. On the first day of February,

the script would automatically change to 211001.

Thank you in advance for any help in creating such a script.

Rob Hunt

I'm not quite sure how you'll do this, but if you ever figure it out I'd highly recommend changing the format to year, month, number like...

YYMM###

-or-

YYYYMM###

This will cause records to be displayed in chronological order when you sort by this field.

You could try using a calculated field, or the Set Next Serial Value script.

although, instead of this format, I would suggest a standard auto-increment primary key field and an order/entry date field (could also be auto entry). This should allow you to run a report that shows you how many jobs you've entered per month.