Two Autonumbers in table

[fjcunninghamjr]

Hi, I am pretty sure I can not have two AutoNumbers in the same form but is there another way to have say a 'short text' field auto fill when I open a new form or is this both the same thing.
Years ago, I named the AutoNumber field the wrong name and now I am trying to change it, if possible.
Thanks for any suggestions.
Frank

[Micron]

Why can't you just rename the field?
I think you'd get more focused responses if you posted about what you have vs what you want rather than ask if some particular thing can be done. Then we might have a better idea on how to fix it. You're right - 1 autonumber field per table (not form).

[ranman256]

nope cant have 2 autos.

[Welshgasman]

Hi, I am pretty sure I can not have two AutoNumbers in the same form but is there another way to have say a 'short text' field auto fill when I open a new form or is this both the same thing.
Years ago, I named the AutoNumber field the wrong name and now I am trying to change it, if possible.
Thanks for any suggestions.
Frank

Yes, I have 5 in a small form of mine. Well they started off as autonumbers elsewhere.
One for the actual table and the other 4 as foreign keys. However then those are not really autonumbers anymore are they?, as it is not necessary for those 4 to be autonumbers.