John, my sympathies!
Make sure you have a unique, primary key on table. I am not sure if this
applies any longer, but I found that including the key on the FILES section
of the update form also helps.
This will result in a correct SQL where clause for the update. Be *very*
careful about deleting records where you do not have a unique, primary key
on table. This could result in dangling members (orphans) and lots of
deletes you don't want.
--
Best regards
James Cooke
Certified Clarion Developer