Fabio
What happens if i add a record in the view? Will it look for the next number in the underlying table's autoinc field? If yes, i hope the autoinc number gets updated in the table. In this case, what happens then if i do a TableRevert? 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.
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
Why do programs stop working correctly as soon as you leave the Fox?