Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need a grid to show parent-child relationship
Message
De
02/05/2008 10:16:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
02/05/2008 10:00:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01314635
Message ID:
01314769
Vues:
18
>>Hello,
>>
>>I guess you know that the VFP grid can show parent child relationships. Right?
>>
>>If you don't know how let me know.
>>
>>Steve
>
>Steve
>
>If I know, I would not asked. Please, show me how.
>
>Thanks

It involves simply setting some properties in the grid, that relate the child grid to the parent table (or grid?) through some properties. This solution uses a specific index to show the corresponding record in the child table. I hope someone else can fill in the details, since I never used this method. Must be something with .ChildOrder and .LinkMaster.

What I wanted to say is that I don't like this method, since, by relying on a specific index, it doesn't let you control the order of the child records, HOWEVER, it is much simpler than using a filter or (better) a parameterized view for the child record, which needs some refreshing through code, and therefore more programming work.

I suggest you try the simple method first, and then eventually change to the somewhat more complicated method of specifying a parameterized view, which lets you control the order in which the child records are shown (through temporary indexes).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform