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.