I have a form that I use to create work orders.
Here's what I need help with:
I want to have a field on the form that has a button that when that button is clicked will generate a work order # in the field. I would like to have the work order based on the Month, day, year and work order for that day.
Example: Today is January 17, 2008. If this is the first work order of the day the Work Order # would be:
01170801, if its the second work order of the day it would 01170802, etc...