Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 20 Jul 2018 at 2:47am

Topic: MedicalDiagnosis.mdb
Posted By: A.D. Tejpal
Subject: MedicalDiagnosis.mdb
Date 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.

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: - uploads/37/


Email: -

Print Page | Close Window