AnsweredAssumed Answered

I need some DB design help

Question asked by docpanderson on May 25, 2015
Latest reply on May 25, 2015 by keywords

Below is a snip of the relationships table that I am setting up. 

Background:  I am developing a database for my Chiropractic office.  I am using the starter solution contact DB as my patient list.  Now I am working on the patient examination.  I have the exam broken into the components you see below.  I have a script from the contact details layout that will open a new exam and give it a new number indicating a new exam.  My problem is that I don't want to have to enter an exam number into each table.  However, I am confused about how to link each table to the central Exam table.    Short of having one enormous examinations table that incorporates all of the sub tables is there a better way of doing this that I am not thinking about?

Exam components.JPG

Any help would be appreciated.