AutoNumber on PK

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
 
R

Rick Brandt

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!

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).
 
E

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top