Here’s one to look at:

These tables have been imported from another Data Base.
I have copied the fields into a new table and they don’t work.
I have made new tables and they seem to be functioning normally

The tables:
Working Links
Customer-House Type
House Type-Elevations
Elevations-test

Non Working Links
Elevations-Options Per Elevations
Elevations- Copy of Options Per Elevations
Options Per Elevation-House Type Materials Details


I’m going to construct new tables from scratch, unfortunately I have over a thousand records in the details table that I’ll have to deal with but what are you going to do?

The reason I’m putting this on the forum is to see if anyone else has ever come across this, or if you know a fix.

It’s always something; as they say,

Joe

I figured it out. I somehow deleted the default value setting in the design view of the table. Without that, Access subforms will enter a null value (instead of the linked value). Breaking referential integrity.