AutoNumber on PK

  • Thread starter Thread starter Eric Dropps
  • Start date Start date
E

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
 
Eric said:
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!
Click to expand...

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).
 
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!)
 
Back
Top