AutoNumber on PK

[Eric Dropps]

Hello, quick question for you all

Is their any way to use referiential interigty with autonumber fields? I
can't use Autonumber with assoative entities, since Access does not allow
two AutoNumber fields.
I can't create a relationship with ref. integrity unless both fields are
AutoNumber

....seems like a catch .22 here!

Thanks, Eric

 

[Rick Brandt]

Hello, quick question for you all

Is their any way to use referiential interigty with autonumber
fields? I can't use Autonumber with assoative entities, since Access
does not allow two AutoNumber fields.
I can't create a relationship with ref. integrity unless both fields
are AutoNumber

...seems like a catch .22 here!

Normally you use an AutoNumber on one side of the relationship and a
LongInteger on the other. There is no requirement that both be an
AutoNumber (especially since that would almost never work).

 

[Eric Dropps]

Ah, I was just using "Number"--and Access said it has to be "the same type"

I'm used to the MySQL world, where you just add AUTO INCREMENT to any
integer data types (smallint, int, etc)

Thanks! (knew it was something simple!)