>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.
OK: I am often not sure whether somebody who asks a question is at the beginner level, at the expert level, or anywhere in between...
> 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 :~)
In that case, my chief suspects would be: 1) corrupted database, 2) corrupted VFP installation.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)