Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a grid to show parent-child relationship
Message
From
02/05/2008 10:16:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
02/05/2008 10:00:08
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01314635
Message ID:
01314769
Views:
17
>>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform