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

Cetin,

It is definatly marked as updatable, so I'll try removing the default.

Thanks for the help.