At 11:50 PM 10-12-02 +0000, you wrote:

> > 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!

Oh gosh! why didn't you say you were trying to use a union-ed set as a
master?
I have no theory about how a master-detail relationship would work where
the master has no real database keys (as is the case with a union-ed
set). You can't perform ANY dml on a union-ed set.

I think you would need to re-architect it so that D1 was the master and D2
the detail. Just have the union query there as a read-only dataset to
supply the ISBN values for parameters for D1's WHERE clause - don't try to
involve the union set in a master-detail relationship at all.

Helen