I have never experienced this phenomena and maybe you guys have - I hope. This has had me occupied most of the day.
T_Main has an attribute linked to T_Attribute (primary keyed). T_Main has the linked attribute set to "Limit to List".
When viewing T_Main attribute you see the drop-down and when testing it, it will only allow blanks or attributes form T_Attribute to be selected.
Good so far, right? So here's my problem.
T_Main has 1,300 records which appear to be blank (null) in the attribute column but when running a query to pull all nulls it says there are none!
Also, when initially opening T_Main, the first record shows an attribute until you run the pointer into that cell and then the attribute disappears.
I have rebuilt the table - nada. Rebuilt the query - nada. What else should I be trying?