>Set filter to works better than a relation when it comes
>to display only some itens of the child table
>
>eg.
>
>SET FILTER TO ALLTRIM(UPPER(FATHER_TABLE.type)) = ALLTRIM(UPPER(child_TABLE.type))
>
>I put the code into the roll_event of the grid, so it happens
>every time I move to a record on the grid of the father table
>
>I am wrong ? I am forcing the system ?
For parent-child relationships, I found that using a parameterized view works better than a filter. And a SET RELATION is not flexible enough, i.e., there is no easy way to create temporary indices.
Specifically, the parameterized view is much faster than a view, especially for larger tables (more than about 20,000 records).
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)