> I believe that I have set the query up correctly, but get the above error

when adding a record(committing it) and then trying to delete it. If I close
the application, reopen and the delete the record, it works.

>
> Generally, what could I be doing wrong.

Your KeyLinks are either incorrect (you should have the primary keys there),
or you have a trigger doing something it shouldn't, or you are not properly
assigning the values to your key columns prior to posting the insert.

In short, the value it stores in the database for the key and the value that
ends up in the buffer with the record are not in agreement. remember, this
is client / server where we have two distinct processes and we have to be
careful about keeping them in agreement on values. Especially keys.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com