The sample db demonstrates an interesting presentation of many to many
relationship between symptoms & diseases. Some of the interesting features
covered in this db are outlined below.
Diagnosis
As the user selects various symptoms in the subform at left, matching diseases (that
exhibit all the selected symptoms) get displayed at right. With the selection of more
& more symptoms, list of diseases gets correspondingly narrowed down.
Data Entry
(a) Integrated interface for data entry facilitates smooth population of junction
table bridging the many to many relationship between diseases & symptoms.
(b) After entering the disease name on main form, the user can select/enter
corresponding symptom in an unbound combo box. If it matches one of the
existing ones in the symptoms table, corresponding Symptom_ID gets entered
directly in the junction table.
(c) If the symptom entered in the combo box is a new one, it gets appended to
the symptom table and newly generated value of Symptom_ID gets entered in
the junction table.
(d) In either case (b or c above), newly added symptom for the disease in
question is displayed duly highlighted in the subform, in appropriate sort order. Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/MedicalDiagnosis.zip - uploads/37/MedicalDiagnosis.zip
------------- --
Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com
|