AnsweredAssumed Answered

Medical database - one to many relationship

Question asked by StevenZangwill on Jun 17, 2015
Latest reply on Jun 17, 2015 by philmodjunk


Medical database - one to many relationship


I know this is simple but I could use some help. Whats the best structure for a rather basic medical database with two different kinds of 1:many relationships. First: one patient - many diagnoses. This can be static so at any given time each patient will only carry one list of diagnoses but I need to easily be able to search all the diagnoses fields at once with one simple search. Should it all be in one file and just use a concatenation field to search all the different diagnoses filed at one time or split into related files. Second: one patient - many hospitalizations. This I was just going to simply make two separate related files. Thanks