Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Environment (Multiple Parent Joins)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00287670
Message ID:
00287774
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform