Auto Number

  • Thread starter Thread starter Vince
  • Start date Start date
V

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
 
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
Click to expand...

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?
 
Back
Top