Hello. I have one question for you guys. I am not sure how approach the problem I have so I hope someone will be able to help me.
Here it is:
I have one table for "Patients" (ID, Name, bla, bla, bla)
I have another table "Visits" which is in one-to-many relationship with table "Patients", so that each individual patient can have multiple visit dates.
Now I want to have a categories of different doctors, lets say 4 doctors.
I am not quite sure how it would be logical to approach this problem?
What is not clear to me:
1. Do I need 1 or 4( each table for each doctor) tables?
1.1. How many tables for my "Categories" must be?
2. What relationship between tables must be(and fields)
3. How can I have multiple categories(doctors) for the one individual patient?
4. How my form should look like: I mean, do I need to use "tick" boxes or something else?
Hope someone who will read this understands what I want to achieve.
Thank you !
Here it is:
I have one table for "Patients" (ID, Name, bla, bla, bla)
I have another table "Visits" which is in one-to-many relationship with table "Patients", so that each individual patient can have multiple visit dates.
Now I want to have a categories of different doctors, lets say 4 doctors.
I am not quite sure how it would be logical to approach this problem?
What is not clear to me:
1. Do I need 1 or 4( each table for each doctor) tables?
1.1. How many tables for my "Categories" must be?
2. What relationship between tables must be(and fields)
3. How can I have multiple categories(doctors) for the one individual patient?
4. How my form should look like: I mean, do I need to use "tick" boxes or something else?
Hope someone who will read this understands what I want to achieve.
Thank you !