Report using custom modules and lookup field

Report using custom modules and lookup field

I have a custom Module Patients with a lookup field for Provider Name which links to the custom Provider module. When I run a report showing all Patients with their Provider Name and Address, the Provider Name is incorrect. Instead of Provider Name it shows Patient Name again. Any ideas on how to get this report to work?