More than one AutoNumber field?

F

FatMagic

Is it possible to have more than one AutoNumber field that are both Long
Integer?

I know Access balks at it when I try - but I was hoping there was a setting
or something that I could just turn off to make it work?

Thanks in advance..

email me at [email protected] or reply here.. thanks!

-Chris
 
L

Lynn Trapp

No can do. You could use a form's event procedures to sequence a long
integer field, however.
 
V

Van T. Dinh

The real question is WHY you need 2 AutoNumber Fields in 1 Table???

The only purpose of AutoNumber Field is to provide *uniqueness* to each
Record in the Table and ONE AtoNumber Field is enough!
 
J

Jeff Boyce

Good catch, Van. I, too, wondered what business need drives the attempt to
solve it with two Autonumbers in the same table.

I would point out that the original poster offers a "how", and we're asking
a "what", as in "what are you trying to accomplish?"

Regards

Jeff Boyce
<Access MVP>
 
Top