If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AutoNumber on PK
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 |
#2
|
|||
|
|||
Eric Dropps wrote:
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). -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
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!) "Rick Brandt" wrote in message . .. Eric Dropps wrote: 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). -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import data into a table with an autonumber field | Martin Watts | Database Design | 2 | March 8th, 2005 07:08 PM |
AutoNumber | Cindy H | Database Design | 1 | January 28th, 2005 01:29 AM |
Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
keeping track of "Escaped" Autonumber records | Paul James | Using Forms | 7 | September 28th, 2004 12:06 AM |
autonumber column | BG | Database Design | 2 | September 13th, 2004 07:45 PM |