Is it possible to have 2 auto numbering features in a table? One would be the general primary key and the other would be whatever 5 digit sequential number I assign. So whenever a new entry is made the 5 digit sequential number would add 1 to the previous number? See example below.


PrimaryKey DocStampNum
1 01858
2 01859
3 01860
4 01861

Many thanks!

Hunter,

Take a look at the DMax() function. It can be used to increment a number 'like' an autonumber.
I think thats what you are looking for.

Good luck,

I've never used this function before so I do not know how to. Can you give me an example on how to. If I assign a 5 digit sequential number lets say 01256, how do I get it to add 1 in sequentia to read 01257?

Thanks.

As Aqua pointed out, you will need a custom auto number.

Here are just a few examples:
Archive 1
Archive 2

also look here http://www.utterangel.com/utterangel.aspx for "Autonumber" without autonumber


Hope this helps ...