[AccessD] Why isn't an index created in the referencing table - or why can't I discover it in design view?

Bill Benson bensonforums at gmail.com
Sun Nov 30 14:24:31 CST 2014


I am probably going to have more than one question while poring over this
document:

http://msdn.microsoft.com/en-us/library/bb177503.aspx

 

My first is that I cannot seem to validate the 2nd of the two sentences in
this sentence pair:

"When you enforce referential integrity, a unique index must already exist
for the key field of the referenced table. THE MICROSOFT ACCESS DATABASE
ENGINE AUTOMATICALLY CREATES AN INDEX WITH THE FOREIGN PROPERTY SET TO ACT
AS THE FOREIGN KEY IN THE REFERENCING TABLE.

 

I have tried this repeatedly in the Relationships window with Table1 and
Table2, where Table1 is the referenced table having pk Table1ID, and trying
to set the relationship by linking that key field to the field
Table2.FKTable1_ID, with referential integrity. I look in the design view,
Indexes, for Table2 (the referencing table) and I do not see any indexes
created there.

 

 



More information about the AccessD mailing list