I have a remote view...
It has a group by clause on the mainkey!

the table is on a SQL server.
It has a key field which is an identity field on the server.
It also has a timestamp field.

I set Send SQL update on and Update all
fields.
IThe SQL where clasue is Key and Modified fields...(But I tried them all)

The update is using UPDATE.

WHat happens is when I browse the table...
If I delete a line or change a line then move to the next line.
It automatically saves the record. (Does it do a tableupdate
when you change line s in the browse???)

But the main thing of confusion is that when I use this view in a grid on my form.
Nothing will save at all.
Except if I delete one line in the grid!

Anyone got any ideas?!?!What's going on here?