Can somebody explain what is going on? I am using the "333 definitions" table five times because many fields in my main table require it, hence the reason why the other tables have naming extensions with _1, _2, _3, _4. In the relationships window, I configure everything as shown in the link below. http://img49.imageshack.us/img49/9094/1stsave1ks.gif I then save and close the Relationships window. Opening the Relationships window again, a split second after just closing it reveals that Access changed the relationships I had set-up. See the link below. http://img49.imageshack.us/img49/4383/2ndopen2sg.gif Why does this happen?