Problems with referential integrity: says there is missing data!

[wes228]

What am I overlooking? I have two tables: Faculty Contacts and Faculty Syllabi in a one-to-many relationship. The Faculty ID is the common field. In the Faculty Syllabi table, Faculty ID is a look-up field with values linked to Faculty Last Name in the Faculty Contacts table.



I have checked every single one: every single Faculty ID that is in the Faculty Syllabi table is also in the primary Faculty Contacts primary table. Yet Access still has an error regarding referential integrity. What could I be missing?

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.

Setting lookups with alias in table is something I NEVER do. Review: http://access.mvps.org/access/lookupfields.htm