C
CK
Hi
I'd be very grateful for some expert advice on my forms please!
I'm having troubles with a subform within another subform in the main
form.....
I'll try to summarise my database first then the problem:
I'm setting up a research database of patients seen in clinic. Each
patient's details are recorded in a "Patient Demographics" form (and saved to
the underlying table). Each patient has a unique ID (PatientNumber). When a
patient presents to clinic with a new problem, this is a new record on the
"History" form/table (this table has TWO primary(?) keys: HistoryID and
PatientNumber). For each problem (as recorded in "History") the patient may
come back for one or more follow-up consultations, each episode a new record
(with a unique ID, ConsultationID) in the "Consultation" form/table. Of
course a patient may return with a NEW problem, generating a new record in
"History" with corresponding new record(s) in "Consultation."
The first two tables (PatientDemographics, History) are linked via
PatientNumber, the 3rd table (Consultation)is linked to the second (History)
via Consultation.ConsultationID to History.HistoryID.
For each record in the PatientDemographics Form, there is a history subform
visible within which is a Consultation subform (in table format). Thus at a
glance one can see the consultations that that particular patient has had for
that particular problem.
The problem:
This works very well EXCEPT when I add a new History record (i.e. a new
problem) for an existing patient who has been seen previously for a different
problem, the consultations shown are still related to the previous problem. i
can't seem to find a way to show only the consultations relating to the new
problem.
I hope this explains the situation adequately and that the solution is
straightforward!
Thanks for your help
Regards
CK
I'd be very grateful for some expert advice on my forms please!
I'm having troubles with a subform within another subform in the main
form.....
I'll try to summarise my database first then the problem:
I'm setting up a research database of patients seen in clinic. Each
patient's details are recorded in a "Patient Demographics" form (and saved to
the underlying table). Each patient has a unique ID (PatientNumber). When a
patient presents to clinic with a new problem, this is a new record on the
"History" form/table (this table has TWO primary(?) keys: HistoryID and
PatientNumber). For each problem (as recorded in "History") the patient may
come back for one or more follow-up consultations, each episode a new record
(with a unique ID, ConsultationID) in the "Consultation" form/table. Of
course a patient may return with a NEW problem, generating a new record in
"History" with corresponding new record(s) in "Consultation."
The first two tables (PatientDemographics, History) are linked via
PatientNumber, the 3rd table (Consultation)is linked to the second (History)
via Consultation.ConsultationID to History.HistoryID.
For each record in the PatientDemographics Form, there is a history subform
visible within which is a Consultation subform (in table format). Thus at a
glance one can see the consultations that that particular patient has had for
that particular problem.
The problem:
This works very well EXCEPT when I add a new History record (i.e. a new
problem) for an existing patient who has been seen previously for a different
problem, the consultations shown are still related to the previous problem. i
can't seem to find a way to show only the consultations relating to the new
problem.
I hope this explains the situation adequately and that the solution is
straightforward!
Thanks for your help
Regards
CK