Originally Posted by
rpeare
Does an appointment *always* result in a test? or do you have people not show up and/or never complete the testing phase?
Is recording the reason they didn't show up relevant?
What are the test results, is it a single score, or do you record different metrics for each test? for instance let's say you were giving someone an eye exam are you simply recording a pass fail or numeric score or are you, for instance, recording their color blindness and degree, then are you recording their left and right eye prescription? My point is that the recording of the test results have very different data points but if you are simply storing numeric values or domain scores that's a different matter entirely and the answer sort of determines how you would go about designing the table(s) that will store the testing results.
In any case, in terms of data entry you will likely have a main form (based on the client), a subform (based on the appointment) and a sub-subform (based on the testing results) if you are using bound controls/forms. Because the results are bound to a specific appointment you want to enforce referential integrity through a form/subform.