L
Liverlass3981
Hi, I hope someone can help advise me. I have a database with a one-to-many
relationship between two tables. In the one table I have the fields
Medication# and then MedicationName. In the many table i have PatientID#,
Medication# (these 2 have keys on them), and then I have the dosage, time and
notes fields.
My problem is that I have a patient who takes a certain medication, e.g ,
medication# 6 but he takes this in the morning and again in the evening, and
the dosage is different for each time. So i want to create a new record for
the morning details and the evening details, but when I put the evening
details in, it won’t allow me to because the patientID#, and medication# are
the same (duplicates) as the previous record for the morning. But the dosage
and time entries are different. So I’d like to be able to enter records for
patients who may possibly have the same medication each time (and date) but
with different dosage and time details. Can anyone advise me what I would
need to do (in simple terms!)?
relationship between two tables. In the one table I have the fields
Medication# and then MedicationName. In the many table i have PatientID#,
Medication# (these 2 have keys on them), and then I have the dosage, time and
notes fields.
My problem is that I have a patient who takes a certain medication, e.g ,
medication# 6 but he takes this in the morning and again in the evening, and
the dosage is different for each time. So i want to create a new record for
the morning details and the evening details, but when I put the evening
details in, it won’t allow me to because the patientID#, and medication# are
the same (duplicates) as the previous record for the morning. But the dosage
and time entries are different. So I’d like to be able to enter records for
patients who may possibly have the same medication each time (and date) but
with different dosage and time details. Can anyone advise me what I would
need to do (in simple terms!)?