--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> 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

Well, MA has an union, and even if I get the data from the same set of
tables/fields, if I qualify D1.P_ISBN=MA.ISBN I get an error (field
not found), so I have to use D1.P_ISBN=ISBN
If I qualify D2.P_D2_ISBN=D1.P_ISBN I get the error Field not found
too... (Fieldname D1.P_ISBN not found)
Sigh!

regards
Marco Menardi