I have three content types: patient, patient medication, and physician.
Using the Node Reference module, patient medication references the patient content type and the physician content type. How can I create a view with a contextual filter that does the following: When I view a physician node, I want to view all patients that the physician has interacted with. Using the two Node Reference fields in the patient medication content type, how can I display a block of unique patients that the physician has prescribed a medication to?
I basically have it set up like a relational table: Patient <-- Patient Medication --> Physician (The arrows represent the node reference)