>Fabio
>What happens if i add a record in the view?

The record is added to the view's buffer.

>Will it look for the next number in the underlying table's autoinc field?

not

> If yes, i hope the autoinc number gets updated in the table. In this case, what happens then if i do a TableRevert?

disregard.

> If not, i then have to start numbering those id's in the view manually, and i will have collisions if people enter records directly in other screens in the underlying table while somebody is working on the view.

This is, but any collision can happen.

You have 3 cases:
- first : at the client side the id is not necessary because none foreign key exists on the interface.
you can set id = NULL

- second : at the client side the id is necessary because some ( not implicit ) foreign key exists,
but only once an id is used;
on this case a id is necessary to maintain the interface's data structure.
You can define a temporary id ( into the buffer ), this can to be a id that exists

- third : at the client side the id is necessary because some ( not implicit ) foreign key exists,
but others id are used;
on this case a id is necessary to maintain the interface's data structure,
but temporary id cannot to be an admissible id.
You can define a temporary id ( into the buffer ), but this id has to be a not admissible value
( for example a negative number, the solution chosen by the VFP Team for buffered recno() )

At the end,
TABLEUPDATE() disregard the temporary id and get the true ID from the autoinc field,
TABLEREVERT() doesn't touch the table.

Fabio

>Jaime
>
>>>Hi All
>>>I have a form where the user enters data through a view. The problem is the underlying table has an Autoinc field with the pk, and people may be adding records there while somebody else is working on the view.
>>
>>Where is the problem ?
>>
>>>The only solution i see is changing the autoinc field to a normal integer and using my NewId() function, but i was wondering if you guys and gals use a different method.
>>>
>>>Thx
>>>Jaime