Sounds like the SQL commands used to delete the record are wrong

Check the Tables, UpdatableFieldList and KeyFieldList properties of the CA against the tables used in the CA.
Check the more obscure Delete* Properties
Check the BeforeDelete and AfterDelete events

Use the Before* Events to check what SQL string is send to the server,


>Hi,
>
>I am troubleshooting a problem. I am trying to delete a record from a table in the SQL Server. I am using cursor adapter.
>On the =tableupdate() command of the CA view, I get error:
>

>Invalid object name 'TableName2'
>

>
>TableName2 used to be in the database. But I removed it some time ago. Where could the connection between the table TableName1 and TableName2?
>
>TIA