Yes, i understand exactly how to create this relationship, thats just it, I know what I'm doing, and so do my superiors and we are all baffeled by this behavior of FoxPro. It just doesnt want to creat this relationship correctly. I know that I must drag, from the parent, the primary key. Take the primary key, and drop it on a regular index in the child, that it is properly related to. I even tried establishing this relationship by coding it and not relying on the slightly easier visual meathods that FoxPro provides. None of these meathods have yeilded differnt results. My boss thinks the machine I use has lost its mind or something :~)