J
Jim Scarlett
Dear All,
I have a Main Form and a subform. The subform is based on a unique table but
does NOT have master/child link fields defined because users may retrieve
records into the subform based on either one of 2 different foreign keys in
the subform table. This table has ContactID as the primary key and 2 foreign
keys JobID and personID. A user can locate contacts by selecting either a
JobID or a PersonID from the main form combo boxes.
I can edit existing records on the sub form (including changing the personID
or JobID) but when I enter a new record I get an error message saying ‘Key
value for this row has changed at the data store. The local row is now
deleted’ (I am using SQL server) Help suggests that there is a trigger
operating on a parent table which cannot find a record to update. But I have
no cascading updates defined on the tables in question.
Any ideas please? Thanks,
jim
I have a Main Form and a subform. The subform is based on a unique table but
does NOT have master/child link fields defined because users may retrieve
records into the subform based on either one of 2 different foreign keys in
the subform table. This table has ContactID as the primary key and 2 foreign
keys JobID and personID. A user can locate contacts by selecting either a
JobID or a PersonID from the main form combo boxes.
I can edit existing records on the sub form (including changing the personID
or JobID) but when I enter a new record I get an error message saying ‘Key
value for this row has changed at the data store. The local row is now
deleted’ (I am using SQL server) Help suggests that there is a trigger
operating on a parent table which cannot find a record to update. But I have
no cascading updates defined on the tables in question.
Any ideas please? Thanks,
jim