When you open Manage | Database | Relationships, what do you see linking Patient Details to Drugs?
Sounds like you may have either the wrong field(s) specified as keys or you may have the X operator instead of =.
You should have a relationship like this:
Patient Details::PatientID = Drugs::PatientID
And PatientID should not be the patient's name under any circumstances here.