Access 2007: Is there a way to run 2 auto number fields in a table?

[MataHari]

I have a database where field 1 scans one of two numbers. It tabs to field 2 where at the moment there is a drop down menu to choose from 1-30. I'd like to change field 2 to an auto number field but my primary key (ID)is an auto number field. Is there anyway to change field 2 to a number field then code it into being an auto number field?

Thanks

[Rabbit]

Why would you need two autonumber fields in the same table? Both fields would have the same value.

[mshmyob]

Unlike other RDBMS Access only allows a single AutoNumber per table.

You would definitely need to use code to increment your values for the second field.

cheers,

[NeoPa]

I've tried to read the question through a number of times, but it doesn't make sense whichever way I do so.

Perhaps you mean that you want field #2 set randomly to any one of the values available between 1 & 30? I have no idea whether this would involve being unique, as there is nothing in your post that indicates that, but whatever it is you do actually want, we can only help if you express your requirements in terms that make sense.