Dear all,
I would like to be able to combine answers from different comboboxes to 1 variable.
Let me explain the situation in my access db:
The database is a medical registration system. In this system one should identify the diagnosis. Doing this happens in 2 steps.
First you have the variable diagnosis: this is a combobox naming 8 parts of the body (general, pelvis, knee etc.)
Depending on the selection a follow up variable appears with a combobox specifying the complaint. So there are 8 follow up variables depending on the choice made in diagnosis. See image:
What I would like is make 1 variable combining the answers of the 8 follow up questions. As every case can only have 1 answer in one of the 8 variables I would assume this is possible but i do not see how. The variable is needed for the next form, the treatment form, were one can select which case the treatment is on. At the moment it looks like the image below but I would like an extra column with the specification of the diagnosis:
I hope the above is clear and someone has the solution .
Thanks in advance.
Kind regards, Daniëlle