>I have a parent table with a compound key field1+field2. I have a child table with the same key. I've tried various ways to populate a grid with the child data while viewing the parent data, but to no avail. I either get no data, or I get all child data regardless of the current key value. What am I doing wrong?
>
>Thanks for any help!
>
>Chaim
What commands did you use in your fruitless tests?
You might try SET KEY TO ..., but this makes it difficult to sort the results.
SET FILTER would also work, but it is slow when selecting a few records, out of a large table.
I think you will get the best performance, plus sorting (with temp indices), with a parameterized view. A view is like query, but allows you to update the underlying tables.
HTH, Hilmar.
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)