Hi
I am stuck. I am trying to make a database for work. It is to keep track of what happens to patients in the service for which I work. I want to be able to see what the current status is of a patient, as well as their history in the service. A patient may have had individual treatment(s), group treatment(s) and have been on more than one waiting list.
So far I have:
tbl_patientdetails
patientID (PK)
name
address
etc
a junction table
tbl_events
patientIDFK
treatmentIDFK
waitinglistIDFK
another junction table
tbl_treatmenttype
individualIDFK
groupIDFK
and:
tbl_individual
individualID
Type of treatment (1-2-1 CBT, 1-2-1 GAT, etc)
Start Date
End Date
tbl_group
groupID
group type (triple group, CBT group, etc)
Start Date
End Date
Number of sessions
tbl_waitinglist
waiting for (1-2-1 CBT, triple group, etc)
Date on waiting list
Date off waiting list
So:
Each patient may have had many group treatments, and each group will have many patients that attended.
Each patient may be on, or have been on, many waiting lists, and on any one waiting list, there will be many patients
Each patient my have had many individual treatments.
What I am trying to do is:
Have a form that has patient details (from tbl_patientdetails), and on that form to have a subform that lists the 'events' that patient are currently engaged in, or have engaged in (e.g. what waiting lists they are, or have been on, what treatments they are have been on). This is the bit I am stuck on.
I think (hope) I have set the relationships up right.
I think I have explained badly... let me know if it is not clear enough.
Many thanks
Bruce
I am stuck. I am trying to make a database for work. It is to keep track of what happens to patients in the service for which I work. I want to be able to see what the current status is of a patient, as well as their history in the service. A patient may have had individual treatment(s), group treatment(s) and have been on more than one waiting list.
So far I have:
tbl_patientdetails
patientID (PK)
name
address
etc
a junction table
tbl_events
patientIDFK
treatmentIDFK
waitinglistIDFK
another junction table
tbl_treatmenttype
individualIDFK
groupIDFK
and:
tbl_individual
individualID
Type of treatment (1-2-1 CBT, 1-2-1 GAT, etc)
Start Date
End Date
tbl_group
groupID
group type (triple group, CBT group, etc)
Start Date
End Date
Number of sessions
tbl_waitinglist
waiting for (1-2-1 CBT, triple group, etc)
Date on waiting list
Date off waiting list
So:
Each patient may have had many group treatments, and each group will have many patients that attended.
Each patient may be on, or have been on, many waiting lists, and on any one waiting list, there will be many patients
Each patient my have had many individual treatments.
What I am trying to do is:
Have a form that has patient details (from tbl_patientdetails), and on that form to have a subform that lists the 'events' that patient are currently engaged in, or have engaged in (e.g. what waiting lists they are, or have been on, what treatments they are have been on). This is the bit I am stuck on.
I think (hope) I have set the relationships up right.
I think I have explained badly... let me know if it is not clear enough.
Many thanks
Bruce
