I have a created a Pageframe with multiple pages. Part of the second page has information containing Enrollments for People. It is a simple case of joining Enrollments to both Organization and to People.

Parent Child Key
Org Enroll Orgid
Person Enroll Personid

When I go to join these tables, I can either join Personid (with the Person Table) or Orgid (with the Org table) depending on which one I join first. I need to get a Organizational Name from Organization matched back to the Person who is in the organization. This seems like either a bug or a very serious limitation in VFP. Can someone help.

Thanks
Greg