I have three files:

Donors, Hospitals and Technicians.

In Donor file I have two fields: RecoverSiteID and ReferralSiteID both are related to the Hospital file and work correctly.

Now I add two other fields, EnucTechId and PreservTechId, to Donor to be related to Technicians in a similar way. Both relationships do not work. WHen I view the Relationships the leftside of the the relationship is assigned to the Technician file and the right side is the Donor, even though I entered them the reverse way. These seem to be the only differences from the other relationships that work correctly. Can someone please tell me what I might be missing?

Edited July 21, 200619 yr by Guest

Hi Dennis

To save a lot of questions any chance you can attach a zipped clone of your files? There cannot be much wrong here

Phil

:shocked: I can't believe I've spent 3 hours looking for this problem only to discover I was using the wrong key on the left side of the relationship!!! How embarrassing!