Instead of using a relation, I recommend parameterized view for the child records. I think this is a reasonable combination of speed and flexibility (the child data can quickly be indexed, to show in any order).
>Hi,
>
>Using VFP6,
>In the data environment of a form I have two tables; the parent and the child with a relation setup between both. In the form when I scroll the parent table, the child recods shows in a grid. It works fine(reasonnable speed) except when I sroll to a parent record which has no child record. When I hit those records, VFP takes forever, like 30 seconds or more, to finally shows me an empty grid. The windows task manager shows the memory usage is full during all that time.
>
>I'm starting to investigate this problem. I'm thinking about looking into different set commands. Any ideas as what I should look first?
>
>Of course I did reindex and pack both tables just in case, no difference.
>
>TIA
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)