MedicalDiagnosis.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 08 Jul 2008 at 10:30pm |
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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |