Topic: Database Design Question
I am not sure how to define this in the Database Tables area.
I have a user table. It's called _user because I'm using the roles feature.
I have a Person table so each user can add a number of persons. I have a relationship of _user in it.
I have a Medication table so each Person can have a list of their medications. I have a relationship with Person in it.
I now want to have a table of Doctor names. It probably would be one set of doctors for the whole family so at the _user level, however each medication will need something that identifies which doctor this is for.
I don't know how to design that. I want a combobox in the Medications form that would show the doctors, then be able to pick one.
Maybe I need to relationships??? One to Medications and one to _user????