>>I have to put 2 grids, based on the same view, on two pages in one form. The two grids share three columns and the other 6 or 7 columns are just different aspect of the same operation, that have to be kept separated for the user to understand the data.
>>
>>How do I base the grids to avoid conflicts during updates?
>>
>>TIA
>>
>>Silvio
>
>>>If you can live with (SQL)WhereType=1 or 4 then it should work without problems.
>================================================================================
>I don't think I see it clear enough. If I use WhereType = 1 and I have changed the same record in both grids, what happens during the update? In my forms all "saves" are wrapped around a single transaction. I guess I should just try it. Thanks for the idea.
>
>Silvio

WhereType=1 means that only key field (primary key?) change may stop tableupdate. It's another story that doing this way you may overwrite first grid record change by second grid record. Is it really necessary for you to make changes directly in grids?