Notifications
Clear all
Topic starter
Does anyone know how to link the PatientProfile table to the Pharmacy table? I'm looking to build a report that shows a list of patients with a pharmacy contact, including the pharmacy's name, type, and state. I've been able to find patients with a pharmacy contact with the PatientProfile table and the PatientRelationship table, but I can't get the pharmacy's name or information.
Thanks!
Bree
Posted : March 3, 2015 12:05 pm
I am not sure if this is what you are looking for but I found a patient by pharmacy report years ago on CHUG. It is a crystal report and basically gives a list of all the pharmacies and the patients attached to each pharmacy. If it is not what you are looking for it may at least hold the code you need.
I tired to attach it to this post but cannot figure out how. I am happy to email it to you if you would like.
Thanks!
Posted : March 3, 2015 12:23 pm
Topic starter
Thank you, but I figured out how to link them. The RelatedPartyId in the PatientRelationship table links to the PharmacyId and then the PatientRelationship table links to PatientProfile by PatientProfileId. Thank you for your help though!
Posted : March 4, 2015 4:13 am
Hi, if you still have a copy of that Crystal Report I would love it! E-mail is [email protected]
Thanks!
Posted : September 26, 2016 6:36 am
