Multiple "AutoNumber" attributes.

[elektrisk]

Hello.


I have a table that connects two other tables. This table contains two keys. I'd like to make both of them "AutoNumber". But, Access will only allow me to set one as "autonumber". How could I compensate for this?

Thanks a thousand.

[llkhoutx]

No, they're not autonumber fields, they are foreign keys and hence numeric (long integer) because they link to autonumber fields.

[NTC]

Access does not permit two autonumber fields in the same table. As you have found out.

So that's the starting point - and it kind of begs the question as to why one ever needs two - - let's say they both are always generating the exact same ID - thus - what's the point of having this duplicate field.....??

So whatever rationale you have for needing two - is wrong....

[maximus]

I completely agree with NTC there is no possible reason on two autonumber fields in a single table. Never the less if you want to save the trouble of entering a number in a field use VB macro to solve your problem.