Thanks Fabio!

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