General information
Category:
Forms & Form designer
Are you doing this through SQL or by setting relationships?
A table can be related to more than one other table as long as the ADDITIVE keyword is used in the second and all subsequent SET RELATIONSHIP commands. Also, you can have multiple joins in your SQL statements.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only