Why does Referential Integrity prevent an update

A

AnExpertNovice

The problem involves a form.

The field being updated exists in one table and is not a key.
The field can be changed by editing the table or when using the underlying
query for the form.

The field can not be updated by changing the field in the form and clicking
save without allowing cascading updates or turning off referential
integrity.
When the command DoCmd.RunCommand acCmdSaveRecord is executed the error
returned is "3200: the record cannot be deleted or changed because table
'tblname' includes related records."

Any ideas what I am doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query Running From Form 2
Problem with Refrential Integrity 5
referential integrity and lookup 2
Referential Integrity Q 3
Referential Integrity and Forms 11
Referential Integrity Issues 5
Referential Integrity for Lookup fields in tables 7
Enforce Referential Integrity not available. 6

Top