Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1-many-many form : How to?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00060850
Message ID:
00061147
Views:
39
>>>>>>I am curious. How do most of you do 1-many-many form? Use parameterized view on the child table and grandchild table and set filter to the grandchild while the child is moving? Or Use parameterized view on the child table and grandchild table and set relation between the two? Or use normal view on both and relate the 3 generations together?
>>>>>>
>>>>>>Is there a best solution?
>>>>>
>>>>>I don't know if it is the best solution, but I use parameterized views for the child and grandchild. I don't set a relation. The parameter for the child is the parentkey, and the parameter for the grandchild is its parentkey. I also have code for my grid that makes the selected record highlighted, even when the grid does not have focus.
>>>>
>>>>Sorry, are you saying grandchild's parameter is the child's primary key? That will mean you need to commit your changes each time you change your child record, right?
>>>
>>>I should mention that my grandchild table isn't exactly a grandchild. It's more like a younger brother. I have a table of "things", related many-to-many with a table of "documents". In my "document" form, there is a grid for the view "thingdocs", which lists the things for a single document. Its parameter is document.dockey. The "things" table has another child called "authorizations". My "document" form has another grid for the view "thingdocauth" which has the authorizations for the currently selected thing in the thing grid of the document form. Its parameter is thingdocs.dockey. In this form, "authorizations" is acting like a grandchild. But I don't edit authorizations in this form. For that, I go to a simple parent-child form which has thing fields on the form and authorizations in the grid.
>>>
>>>My Save button does TABLEUPDATE on each open cursor.
>>
>>Your grandchild's (authorization) child order is actually the grandparent's (document) key, right? I guess that is the only way to have grandchild as parameterized view.
>
>My authorization records are ORDER BY a different field. The parameterized view only selects records whose thingdocauth.dockey = ?thingdocs.dockey. It doesn't need to be ORDER BY dockey, because all selected records have the same dockey.
>
>I forgot to mention that I REQUERY('thingdocauth') in the thingdoc grid.AfterRowColChange. Both views get REQUERYed in refresh.

I am sorry. I got confuse and wrote childorder instead of parameter. What I wanted to ask was: your parameter for the child and grandchild views are actually the same, right? Because thingdocs.dockey = document.dockey, therefore it is as good as saying your grandchild is referring to the grandparent for the parameter. That is why you mention your grandchild is more like a brother.

If the view is an actual grandchild, I can't think of anyway I can use parameterized views for both and yet keep them in buffer.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform