I am clueless as to how to go about this. In short, I need to determine if a patient's primary office is one that their doctor has worked at.
Here is more detail:
On any given patient's profile there is a primary office and doctor. They are both one to one relationships. The two fields are independent of each other. I have a list of the doctor's with all of the offices they have worked at. Some have worked at more than one, some split their time between offices. I am trying to take the doctor's name from the patient's profile, look it up in the list of doctors, and check that the office in the patient's profile is one in the list, i.e. check that the doctor has in fact worked at that office.
Examples:
Patient A is assigned to Dr. Smith and the Chicago office. The list of doctor's says Dr. Smith has worked at the New York office and the LA office. In this case, I would want a flag that says the Doctor has never worked at the office on their profile.
Patient B is assigned to Dr John and the Seattle office. The list of doctor's has Dr John currently at the New York Office and previously at the Seattle office. In this case, I would want a flag that says the office on the patient's profile is a location the doctor has worked at.
I am not even sure where to start.
