>>(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

you need to look at paramaterized views. if you read anything at ut on grids you will see this recommendation many times over. there is some information in the developers guide. i have never implemented, but played with one and got it working in under an hour. need databases and a unique key on your table. parameterized view is similar to SQL, but is updatable.

brenda