OK newbie here. . but do have comment/question. Even though many patients can have many alergies. . wouldn't it be a one to many relationship because you are only reporting for the one specific patient with (one or many) alergies at a time?
Originally posted by dynamictiger
Isn't this a many to many relationship patient to Allergy? Tht is many patients can have many allergies, some will only have one.
Thanks for your replies. Now after I create the tables as you have mentioned I want to create a continuous forms in access like this
Header: Patient Name | AllergyName_1| AllergyName_2|...
Data: | AllergyDate_1 | AllergyDate_2 |...
I think a subform approach may work better for you. Create a subform for the AllergyID/PatientID table, and present this on the form for the patient details. In this way you could, for example attach a photo of the allergic reaction, or other patient data and present great information to your user.
It is upto you, and knowing what the data is used for will determine your approach.