Hi Newsgroup,

I am using FP5 and Win2k.
I have 3 databases in use. db-A is related to db-B and shows the data from
db-B I want to see correctly.
Now I would like to have a portal in DB-C which is also related to db-A (in
a differnt way as DB-B) to show the data from db-A which suite the
relationship. But I can only see the "real" db-A data and not the data which
is "imported" from db-B.

How can I manage to make all data show up in the portal?

Thanks, Raimund

On 9 Jul., 19:34, "Schröder Raimund" <r.schroe... [at] aon.at> wrote:
> Hi Newsgroup,
>
> I am using FP5 and Win2k.
> I have 3 databases in use. db-A is related to db-B and shows the data from
> db-B I want to see correctly.
> Now I would like to have a portal in DB-C which is also related to db-A (=
in
> a differnt way as DB-B) to show the data from db-A which suite the
> relationship. But I can only see the "real" db-A data and not the data wh=
ich
> is "imported" from db-B.
>
> How can I manage to make all data show up in the portal?
>
> Thanks, Raimund

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=2E5. Seriously, you will not regret it. It's a major leap.

/biberkopf

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

> Hi Newsgroup,
>
> I am using FP5 and Win2k.
> I have 3 databases in use. db-A is related to db-B and shows the data from
> db-B I want to see correctly.
> Now I would like to have a portal in DB-C which is also related to db-A (in
> a differnt way as DB-B) to show the data from db-A which suite the
> relationship. But I can only see the "real" db-A data and not the data which
> is "imported" from db-B.
>
> How can I manage to make all data show up in the portal?

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)