Hi everyone,
I am new to ms access and I'm trying to create a database from scratch to use in my medical practice. As one would expect I've come across several issues which I was able to solve from forums and such, yet right now I am having a problem which I can't seem to find the best solution and I would very much appreciate your help.
The database refers to 200 inpatients in a 3 month span and so far I've created two tables in which I organized the information:
»» Table 1: I called it Demographics Data and It states the patient first, middle and last name, his/her age, sex and so on, like this:
ID (auto number) FirstName Middle Name Last Name Age Sex
1 John Brewer Smith 45 Male
»» Table 2: I called it Hospitalization Data and I put the date of admission, date of discharge, duration of hospitalization, patient's status at discharge and so on, the structure being the same as table 1. Also, I created a relationship in which ID in table 1 relates to ID in Table 2, so that I can create a form and a subform in which I am able to introduce all the information to populate my tables at once.
The third table is the one I am having trouble with. It will state each patient past history. As you may guess a given patient will have various past diseases and I need to create a table that states all of them and relates them to the patient in table 1. My first issue is the table design. Should the table state the several diseases like disease 1, disease 2, disease 3 and so on or is there a better solution?
Finally, I need that this table be related to the patient table so that I can fill the above mentioned form with each patient information.
Again, I would very much appreciate your help.
Gonçalo