Auto Number

[Vince]

Hi,

I know you can only have one Auto Number in the table but
I would like another one....is there any way to code one?
Much help appreciated.

Vince

 

[John Vinson]

Hi,

I know you can only have one Auto Number in the table but
I would like another one....is there any way to code one?
Much help appreciated.

Vince

Ummm... WHY?

An Autonumber has one function, and one function only: it's an
almost-guaranteed unique key. It's not necessarily sequential, it will
always have gaps, it can become random.

Displaying even one autonumber to users is fraught with problems.
Displaying TWO (arbitrary, unrelated, non-sequential) autonumbers
seems completely pointless.

I suspect there is a better way to accomplish the business need for
this - could you please explain what you're trying to accomplish this?