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 11:22:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
02/05/2008 10:58:29
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:
01314807
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).
>
>Hilmar
>
>I used Parent and Child grids before and I know how to use them but that's not what I am looking for. I am looking for showing Parent-Child relationship in one grid (not 2).
>
>Long time ago, I used Infragitics UltraGrid with VB and it worked great but it does not fit well with VFP. I believe this days they are dealing with Web objects only.
>
>Check the following for an example of what I am looking for.
>http://www.infragistics.com/dotnet/netadvantage/aspnet/webgridgallery.aspx
>
>see the ones. data Entry support, Expansion Indicator and you know what I need.
>
>Thanks

That one looks real neat; I don't think you can do something similar with built-in Visual FoxPro grids. The closest I have seen - but still more limited - is the TreeView ActiveX control.

I suppose you will have to search for third-party tools to get this kind of presentation. OK, that was precisely your question; but I don't know of any.

Hilmar.
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
Reply
Map
View

Click here to load this message in the networking platform