E
etter34
I'm trying to develop a form and I'm not quite sure what is the best
way to proceed.
Any guidance / help would be appreciated.
I'm working with diagnoses and problems and need to track this
information based on a case by case basis (patients). The problem is
that cases / patients have multiple diagnoses and problems that need to
be inputted into a table linked to the main patient table.
What I thought of doing was having a subform with multiple comboboxes.
The first combobox would list broad caterogies of diagnoses (ie:
trauma, toxicity, metabolic, etc.); the next combobox would contain
more specific details within those headings. So if one chose trauma in
the first combobox, the second combobox would populate with items like
"fracture, laceration, luxation, etc." And the user could select them.
However, diagnoses can include multiple problems from the broad
heading.
Example:
Patient 1:
Trauma: Fracture, Laceration
Infectious Disease: Abcess, Sepsis
Patient 2:
Degenerative: Cataracts
Metabolic: Starvation
So that now when I change the first combobox, the second combobox
reacts accordingly and I lose the data.
I'm looking to record each problem in (probably multiple) fields so
that I can later run queries using either the broad category, or the
more specific one.
THe two combobox example might not be the best idea, so thats why I am
looking for help. I thought about making the second combobox a list
that could be used to populate another list that would save all of the
problems to the patients record.
I'm not sure how else to explain this without showing the database.
way to proceed.
Any guidance / help would be appreciated.
I'm working with diagnoses and problems and need to track this
information based on a case by case basis (patients). The problem is
that cases / patients have multiple diagnoses and problems that need to
be inputted into a table linked to the main patient table.
What I thought of doing was having a subform with multiple comboboxes.
The first combobox would list broad caterogies of diagnoses (ie:
trauma, toxicity, metabolic, etc.); the next combobox would contain
more specific details within those headings. So if one chose trauma in
the first combobox, the second combobox would populate with items like
"fracture, laceration, luxation, etc." And the user could select them.
However, diagnoses can include multiple problems from the broad
heading.
Example:
Patient 1:
Trauma: Fracture, Laceration
Infectious Disease: Abcess, Sepsis
Patient 2:
Degenerative: Cataracts
Metabolic: Starvation
So that now when I change the first combobox, the second combobox
reacts accordingly and I lose the data.
I'm looking to record each problem in (probably multiple) fields so
that I can later run queries using either the broad category, or the
more specific one.
THe two combobox example might not be the best idea, so thats why I am
looking for help. I thought about making the second combobox a list
that could be used to populate another list that would save all of the
problems to the patients record.
I'm not sure how else to explain this without showing the database.