Hi,

I've a sqlserver (isnt that great ?) with a table. In this table there is one field that is an identity field and is set to auto-numbering. This table is viewed via a grid in a visual foxpro form.

The user can create/delete/modify the data via this grid. Buffering is set to optimistic row buffering.

The keyfield that is set to auto-numbering in the sqltable is set to readonly in the grid.

The problem is that when a user has created a record that the keyfield stays empty. So we have to do a requery to update this field in the view.

That is not so good because afther te requery the recordpointer isnt at the right record (the one last created).

So here is my question : is it possible to get the right value for that keyfield in the grid without doing a requery and losing the focus on the good record ?

Thnx