Thanks, Ricky. Now that I understand it, it appears to be pretty obvious. I feel like a fool. An enlightened fool.
And yes, a patient can have several Drs. and Diagnosis, but for the purpose of my database, I am tracking certain patients, their referring physician, their main diagnosis and...