I am grateful for any answer that can help me understand, than you..
In addition to what is demonstrated in that thread, in FileMaker, it can be necessary to refer to data that is "Several relationships away"
You might have:
and need to refer to data in TableC from the context of TableA. FileMaker can do this because it always insists on relationships that only have one possible path from any table occurrence to any other table occurrence. If there was an additional relationship that linked TableA Directly to TableC, there'd be no way for FileMaker to determine which "path" to evaluate in order to access related data in TableC.
If you try to set up these relationships:
You'll get a message popping up telling you that you have to create a new "instance" (should say "occurrence") of one of your tables when you attempt to create the last relationship that creates such a "circle". By adding that new occurrence, you can get the relationships you need without breaking this "no circles" rule.
I thank you both for your help. I did understand the thread Marc gave on top and also PhilModjunk's as well. This is the kind of problem one might understand later on by doing stuff, but it just bothered me not to understand the connections here. Thans a lot.