I've read a lot of post on this type of incrementing numbers but it as usual with notes there are some caveats. This is my problem: I need to create a PO Number using DeptNum(field on the form) + yyyymmdd + a sequencial 2 digit number, I need to make sure that the number is not duplicated (biggest issue from my understanding) The application resides on one server, the PO number will be added by one of 2 people, once the request has been approved. It can be generated at any point after the VP has approved the request.
My thoughts: The form has a field that will display approved once the VP clicks a button. He will then close the form and the workflow will send an email to the group that does the ordering. I'd like the number to be generated from the time the VP closes the form (via agent I think would be best) this way when the order group opens the db they see the PO number. I know this is not an easy one, so all your help and recommendations will be taken into account, I'll try anything!