Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Environment (Multiple Parent Joins)
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00287670
Message ID:
00287774
Views:
20
Ok, then what you need is a parent-child-grandchild relation.

Basically, you need to relate Person into Enroll, then Enroll into Org. So you're main table ends up being person. Then, on the second page, your grid's recordsource is Enroll which will then show you the orgs.

>I have fully normalized the model for VFP so let me try this again.
>
>Three tables:
>
>Org (Decode Table)
>Orgid
>Orgnm
>
>Enroll
>Orgid
>Personid
>
>Person
>Personid
>Name
>(Other details about the person)
>
>I want to relate the Person to his/her enrollments and display the Organization name. Three tables are involved in this. I know how to do this in SQL (been doing Relational Database Techology since early 80s (Ingres, Oracle, SQL/Server, DB2)) The question is how do I do this in a GRID on Page2 for VFP
>
>The first screen has information about the person.
>
>So page 1 would show
>
>Person,
>Address
>Phone
>
>Page 2 would show only the organization names he is enrolled in (Grid format). Nothing else .
>
>Thanks
>Greg
Travis Vandersypen
Previous
Reply
Map
View

Click here to load this message in the networking platform