I have a form - mFrmPatientDetails (with combo box). User selects patient from combo box.
Each patient has a treatment (with multiple sessions) This is the sFrmTreatmentdetails. Each treatment has an ID (autonumber). (PK) It is linked to the mFrmPatientDetails via PatientID.
This is the first sub form. Then this form has a sub-form (sessions per treatment).
It is linked to the sFrmTreatmentdetails.via PatientID and Treatment ID. What I would like help with is what do I need to add to (a) the treatment form to make it stable (b) to ensure the combo box always reflects the current patient - to ensure the correct patient is updated (c) How can I make sure that the right treatment is applied to the right patient and the right session details applied to the right treatment & patient. Am attaching a file with my current work sub-sub-form-example.accdb