Subject Re: [IBO] Master detail detail and MasterParamLinks
Author Helen Borrie
At 10:30 PM 10-12-02 +0000, you wrote:
>Hi, I've a master-detail-detail relation
>The problem is that I want to "propagate" a field value from the
>master to the "detail-detail" through the "detail", i.e.
>MA.ISBN -> D1 -> D2
>since MA.ISBN is important for D2 also (plz., don't question about the
>design, be sure this is the right way for my "too complex to explain
>here" problem ;)).
>
>D1 uses the MA.ISBN field as P_ISBN=MA.ISBN with MasterParamLinks
>
>but D2, that is linked with D1 as it's master, how can "read" P_ISBN?
>I've tried P_D2_ISBN=P_ISBN, but does not work...

What happens if you qualify the columns at all levels, i.e.

D1.P_ISBN=MA.ISBN

and

D2.P_D2_ISBN=D1.P_ISBN

Helen