On 9 Jul., 19:34, "Schröder Raimund" <r.schroe... (AT) aon (DOT) at> wrote:
Hi Raimund:

FP5/6 is seriously limited when it comes to relations. You can only
'look back' one step. You should consider upgrading to FileMaker 8.5
which is SO much nicer to work with in all respects. But if you
insists you should probably build some fields in the db in the middle.
Here you can store the related results. There has been a ton of this
type of work around in the good ol' version 3/4- and 5/6-days. Another
way is to redo emulate the A-B-relation with a second C-A based on a
global and some scripting. This is a dirty way of solving your needs,
but it is a possible solution. Anyway, I'd still advice you to go for
8.5. Seriously, you will not regret it. It's a major leap.

/biberkopf

In article <46927013$0$2252$91cee783 (AT) newsreader01 (DOT) highway.telekom.at>,
"Schröder Raimund" <r.schroeder (AT) aon (DOT) at> wrote:

You can't "double-jump" Relationships from a parent to the
child-of-a-child. You also can't have a Portal inside a Portal.

If you want data from db-B to appear in db-C, then you'll need to put
Calculation fields within db-A which copies the data from db-B via the
relationship.
ie.
c_MyField_FromB Calculation
= rel_AtoB::MyField

This field will then be available to db-C via its Relationship to db-A.

BUT, that will only obtain the data from the FIRST related db-B record,
not all of them.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)