David-

>From a lay point of view, since I dragged from the wojrn table to the opindex table, I'd call this many-to-one...but what do I know?
In the DataEnvironment, you can click on the relations line and display the properties sheet for it. Releations have a property for Many-to-one. It is false by default. You will want to change it to .T. if you need it to be many-to-one.

As for learning about relations...I learned about them so long ago, and not from Fox, that I don't really know how crystal clear the docs are from your pov. But, I think they are rather alright. Just takes practice, in my mind.

More later...I've run out of time for now, but check the relationship. Try simplying as I suggested if you're still having trouble, and let me know.