A
AnExpertNovice
Issue:
I think this may be a forms issue (actually a user error!) because the table
can be updated directly but not when using the form.
Specifically, the form has bound fields and references a single table
(Table1). Table1 is related to Table2 and Referential Integrity is turned
on but "Cascade Update Related Fields" is turned off. (the database is
being worked on as side work but is currently being used in a more manual
mode. Until the database is coded I want Ref Integrity on and Cascading
turned off., if at all possible.)
The field being edited, "LastName", exists only in Table1, is not part of a
key, and is not related to another table. When a record is updated by
changing "LastName" on the form with Referential Integrity turned on and
"Cascade Update Related Fields" turned off the following error is generated.
"3200: the record cannot be deleted or changed because table 'tblTable1'
includes related records?"
Any suggestions on what I am doing wrong?
I think this may be a forms issue (actually a user error!) because the table
can be updated directly but not when using the form.
Specifically, the form has bound fields and references a single table
(Table1). Table1 is related to Table2 and Referential Integrity is turned
on but "Cascade Update Related Fields" is turned off. (the database is
being worked on as side work but is currently being used in a more manual
mode. Until the database is coded I want Ref Integrity on and Cascading
turned off., if at all possible.)
The field being edited, "LastName", exists only in Table1, is not part of a
key, and is not related to another table. When a record is updated by
changing "LastName" on the form with Referential Integrity turned on and
"Cascade Update Related Fields" turned off the following error is generated.
"3200: the record cannot be deleted or changed because table 'tblTable1'
includes related records?"
Any suggestions on what I am doing wrong?