T
Ted Collins
I'm trying to create a form with a subform to do an update.
The master form has a field named 'ClassID' which is the
primary key in a table named 'Class'. The subform updates
a table named 'Access' with a field named 'ClassID' that
has a one-to-many relationship with 'Class'.
The 'ClassID' field on the master form is a combo-box
using the 'ClassID' field of the 'Class' table as its
source. When I choose a ClassID, the subform updates to
show the appropriate information from the access table.
The problem: If I try to change focus from the ClassID
field of the master form, I get the following error:
"The record cannot be deleted or changed because
table 'Access' includes related records."
What do I need to do to be able to update the Access table?
Ted C
The master form has a field named 'ClassID' which is the
primary key in a table named 'Class'. The subform updates
a table named 'Access' with a field named 'ClassID' that
has a one-to-many relationship with 'Class'.
The 'ClassID' field on the master form is a combo-box
using the 'ClassID' field of the 'Class' table as its
source. When I choose a ClassID, the subform updates to
show the appropriate information from the access table.
The problem: If I try to change focus from the ClassID
field of the master form, I get the following error:
"The record cannot be deleted or changed because
table 'Access' includes related records."
What do I need to do to be able to update the Access table?
Ted C