Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - MedicalDiagnosis.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

MedicalDiagnosis.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: MedicalDiagnosis.mdb
    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.

Download Access XP & 2K: uploads/37/MedicalDiagnosis.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down