adding a sequential number to a form

[ST]

Is there an easy way to add a sequential number everytime you fill a new
form?

An example would be an invoice. For every new invoice that you create you
would have an invoice number.

Thank's

ST

 

[Roger Jennings]

The most common practice for assigning sequential invoice numbers is to use
a networked database table with an int identity (AutoNumber for an Access
..mdb) primary key column. This approach is essential when a form has more
than one user. (InfoPath handles identity and AutoNumber columns
automatically for INSERT operations.)

A workaround might be to store the last invoice number in a shared text file
and update the value with script or managed code (SP-1), but this requires a
fully-trusted form to access the file system and isn't likely to be very
reliable.

--rj

 

[ST]

Thank's Roger.

The most common practice for assigning sequential invoice numbers is to use
a networked database table with an int identity (AutoNumber for an Access
.mdb) primary key column. This approach is essential when a form has more
than one user. (InfoPath handles identity and AutoNumber columns
automatically for INSERT operations.)

A workaround might be to store the last invoice number in a shared text file
and update the value with script or managed code (SP-1), but this requires a
fully-trusted form to access the file system and isn't likely to be very
reliable.

--rj