Designing forms that will be numbered in sequence

L

L

I would like to design a purchase order form. These forms
will be numbered for reference in numeric sequence. Is
there a way that every time the form is accessed it will
open and be numbered in numeric sequence?
 
J

Josh Bertsch [MSFT]

This is certainly a popular question! And as such, it has been answered
many time in this forum. I would suggest an approach of combing through
this newsgroup or searching with the "groups" section in google.

In general, there are a few ways you could do this. If you are using a
database, set one of the fields to increment everytime you create a new form
entry and use that number. Or use a web service that would get called and
get incremented everytime you open a form. There is no native way to do
this in InfoPath.

--josh bertsch
 
J

Jerry Thomas [MSFT]

You can get unique and very close to sequential using a combination of user
id and a Date and Time stamp.
It is possible you would get 00120041005095412 and 00220041005095412. Notice
the first 3 digits. Employees 001 and 002 created new POs at the same time -
2004-10-05 09:54:12.

For truely unique and sequential, you will need to create a seperate file
that just has the PO number. Using script, open the file, increment the
number and then save and close. You would need to code for situations where
the file was open and locked, etc.

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.
 
Top