If table A has a autonumber data type, and it's the primary key in table A, and then it appears in table B as a foreign key, with the same data type of autonumber, [ with table B already containing autonumber for it's own primary key], i get an error message that "no more than one autonumber allowed in the same table". Table B will save if I change the foreign key to "number" data type. Does this sound correct? I'd like to start using autonumbers more and more if possible. thanks.
2007-11-29 13:53:50 · 1 answers · asked by 27ysq 4 in Computers & Internet ➔ Other - Computers
What You have done is correct.
There can be only ONE "Autonumber" field Per table, and it should be the Primary Key (or one of your key fields) since it generates a UNIQUE ID for each record. Table A's key-field has to be a "number" in Table B, since it may be repeated.
You may want to take a quick course on Access development. http://www.free-ed.net has a good one that is free.
2007-11-30 07:11:01 · answer #1 · answered by Capt Crasher 6 · 1⤊ 0⤋