VCPP 5.0, MFC, DAO, Win95
I have a database design question. My application is used in the medical community and will contain patient information and test data from a number of different tests. The separation is between the different tests. Does anyone have any suggestions on if or how I should separate my exam tables from the patient information table. And what is the best way to link the patient information to the various exam tables. Should I create a unique exam ID field, for each exam type, in my patient information table that accesses my different exam data in the exam table? Is there a different and better way to link the data in my tables? All suggestions welcome.