>>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?