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?
Any help would be appreciated.