Still doesn't work.

I have solved the problem by trapping the BeforeDelete event, using
a separate delete statement, then Aborting the delete.

I still have no idea why this doesn't work, but perhaps another
time...

Thanks for you help Helen,

rick

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 04:57 PM 29/01/2005 +0000, you wrote:
>
>
> >Perhaps it would be easier to ask what should I have in these
> >properties?
>
> :-) Yup. "All is revealed".
>
>
> >The Join in this query is only for purposes of the Order by,
where I
> >am using the I.NON_SEED_ITEM to sort along with II.ITEMNAME.
> >
> >I have the following settings:
> >
> >KeyLinksAutoDefine: unchecked
> >
> >KeyRelation: INVOICEITEMS
> >
> >KeyLinks: INVOICEITEMS.ITEMNUM=ITEMS.ITEMNUM
>
> This is wrong. That syntax of KeyLinks, along with the
KeyDescLinks
> property, have nothing to do with your current situation (they are
used for
> implementing the KeySource-Lookup relationship).
>
> Change your KeyLinks to
> INVOICEITEMS.IDNUM
>
>
> >KeyDescLinks: blank
> >
> >JoinLinks: blank
> >