>I have a form with a grid one it. I have a parent table with seperate records on the primary key index and I have a child table with it's primary key relating the parents, but with a one-to-many relationship. I use the set relation into code so when I enter this screen it shows only the 1-? records that match on the related number of the parent in the grid. That works perfect. The problem is I use the set skip to code to tell it that the child can have many records related to the parents, but that does not seem to work. In say one with 3 records showing, I can select the first one and the last, but if I select the middle one, it jumps it to the first (top) one. Why does the set skip to not work properly?
Is it possible to use local parameterized view instead? SET SKIP may have problems...
Check
Re: Need a grid to show parent-child relationship Thread #
1314635
If it's not broken, fix it until it is.
My Blog