I have a form that I want to display values from tables or queries that are
not part of the form or subform. If I make a relationship with the table or
query that has the information I want displayed, it makes the record set
non-updatable. As a result, I am thinking that an unbound field is the way to
display the data.

The way the database is structured, there two seperate forms one is
appointments including subforms of related data (this is where I want to
display the Chronic Care Status) and the other form is diagnoses with its
subforms and related data. Diagnoses is where the Chronic Care is available
and displayed. However as stated when joining the two Appointments and
Diagnoses, the records are not updatable.

My question is how can I display the Chronic Care status in the Diagnoses
table on my Appointment Subform.