More than one AutoNumber field?

[Guest]

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 (e-mail address removed) or reply here.. thanks!

-Chris

 

[Lynn Trapp]

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

 

[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!

 

[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>