>Hi,
>
>I'm going round in circles so some help would be appreciated.
>
>I have an Updateable view who's base table has a unique ID (from a lookup table), the base table has a default value that is a function that gets the next ID - that's all fine however when I add a record to the view it doesn't have the default value in it so I've set the same call in the default value of the view - how I'm finding that the ID is incrementing twice!
>
>How should I be doing this?
>
>Thanks in anticipation
>Caroline
Caroline,
You probably not marked keyfield as updatable. Since it's not updatable it's not sent back causing NewId to get a value for the second time. Either mark it updatable or remove default from view field properties.
Cetin