table design problem

[BEJW]

Hello,

I have the 2 tables one is called a Patients another is called a Examinations. The following are my tables: It seems that have the probles there. Since A
patient can have multiple examinations on multiple dates.
Anyone can tell me what is the best way to design these table.

Thanks a lot.
JW




Patients
-------------
PatientID
First Name
Last Name
DOB
Education
Diagnosis
Diagnostic Code
SH



Examinations
-------------
Exam_ID
Patient_ID
FrSBE Total
DRS Total
MMSE Score
APeE GeneType
Visit Date
Date Of Evaluation

 

[JeremyNYC]

JW,

What's the problem?

JW

PS: You might want to get rid of the spaces in your field names. They will cause you LOTS of pain and extra typing as you build this database.

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.