>>(long enough i could read which record it was) then go blank. finally made a temp table with only the subset of records i needed and only displayed those.
>
>I found a way that works for the grid content.
>with grid2.RecordSourceType = SQL Statement
>and grid2.RecordSource = SELECT * FROM table2 WHERE field1=table1.field1
>
>This works well, but I need to modify content in grid2.
>Can I do something similar and have grid2 not ReadOnly?
>
>Claude
Hi Claude,
You might do similar thing with a readwrite cursor but it wouldn't in the context you think and would be more complex to update (although one of preferred ways).

Views would the most suggested one and I suggest too but again this one needs more experience than other following ways. BTW Brenda, you're progressing fast, I should correct something for your future reference, views not really need basetables be in a DBC and have unique indexes. Views themselves should be in a DBC and might refer to base tables from ie: fox 2.x free tables with no actual unique index. This provides a way for free tables be contained in a transaction + fox2.x - vfp apps work with same free tables.

Now in your relation as Barbara stated, childorder seem to be wrongly set. :

use parenttable in 0
use childtable in 0 order tag reltag
select parenttable
set relation to parkeyfield into childtable

* Correspond to properties of child grid
Childorder = "reltag"
Linkmaster = "parenttable"
RelationalExpression = "parkeyfield"

If set correctly this would show the correct set + do not need relation in DE. But beware childgrid order shouldn't be changed on the fly.

The easiest (but to me the worst) solution is to use a filter on child grid.
Cetin