Number generated automatically 1

[Angelique21]

Hi All,

I need to generate a number that each time increments by one, that is takes the next number in line. For example I have an OrderNo Field that each time the user wants to create an Order he must first book the next Order Number in the Form. The Order number thus must be unique, in sequence and its format must be PI 07/--- the first one being PI 07/001. If a second user wants to book an order number the following must show up PI 07/002 etc.

Any suggestions of how I can go about it?

Thanks a lot for any help

 

[MichaelRed]

search these fora (and hte faqs in particular) look for custom autonumber.




MichaelRed