Autonumbers - How to generate a reference...

[fateyes]

Hi,

Simple request...

I need to generate automatic order reference numbers, Starting with something along the lines of : IND_0000123 and increasing automatically from this point....

Thanks for any help

Fateyes

 

[smed]

When working with serial number I would not advised use a field which is set to autonumber. (There are many reasons for this)

A possible solution would be to only allocate the order# to a form field once a record has been saved.

The order# number would be automatically generated by using a query to determine the last order# and then +1.

This number is then placed into the form field with the prefix IND.

Smed

 

[fateyes]

thanks smed - do you think you could give me a hand writing the expression for the query?
And im not sure about how to do this - "only allocate the order# to a form field once a record has been saved."

cheers

 

[smed]

I have attached a sample db for you to look at.

Smed