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

 

[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!)