At 02:48 PM 28/01/2005 +0000, you wrote:

>Still no joy.
>
>When I erase the DeleteSQL and set the KeyRelation to INVOICEITEMS,
>I get "blank SQL statement not allowed".
>
>When I try the "IDNUM = :IDNUM" in the DeleteSQL I still get the
>same message: "Invalid reference to delete".
>
>I have KeyRelation set to auto define

KeyRelation doesn't have "auto define".

>and the KeyRelation property left blank.

KeyRelation should contain the name of the (one) table that is to be
updatable/deletable/insertable.

>Should something be here?

Are your KeyLinks accurately defined? KeyLinksAutoDefine won't help you
for a joined set...

Helen

>