Query not updatable

[Kurt]

I have a continuous subform (frmPerpetrators) linked to a main form
(frmVictims). The forms are linked by CaseNumber.

- The main form is based on qryMedicalIntake
- A victim can have multiple perpetrators.

When a victim is selected in the main form, I’d like the subform to show the
perpetrator(s) for that victim using data from a table which is linked to
another database (tblLinkedPerpetrator). For this purpose, this query works:

qryPerpsLinked:

SELECT tblLinkedPerpetrator.CaseNumber,
qryMedicalIntake.PatientName,
tblLinkedPerpetrator.PerpName,
tblLinkedPerpetrator.Relationship
FROM tblLinkedPerpetrator INNER JOIN qryMedicalIntake
ON tblLinkedPerpetrator.CaseNumber =
qryMedicalIntake.CaseNumber;

However, instead of just showing information from the linked table, I would
like the user to be able to *enter two new pieces of information* regarding
each perpetrator listed in the subform, and have that information saved in a
different table in the current database. (I realize this is not the best
design but changing the design is not an option at this time.)

If I didn’t need to include data from the linked table, this query would
work for the purposes of just adding data to the subform:

qryPerpsAdd:

SELECT qryMedicalIntake.PatientName, tblPerps.*
FROM tblPerps INNER JOIN qryMedicalIntake
ON tblPerps.CaseNumber = qryMedicalIntake.CaseNumber;

But when I tried to create a query which brought together data from the
linked table (tblLinkedPerpetrators) and the two fields in the nonlinked
table (tblPerps), the query was not updatable (i.e., the user can’t enter
information in those two new fields). What am I doing wrong?

I tried joining qryPerpsLinked and tblPerps, but this isn’t updatable:

SELECT qryPerpsLinked.PerpName,
qryPerpsLinked.Relationship,
tblPerps.PerpStatus,
tblPerps.PerpConfess
FROM qryPerpsLinked LEFT JOIN tblPerps
ON qryPerpsLinked.CaseNumber = tblPerps.CaseNumber;

Any ideas? Thanks.