>>>>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.
>
>I'm stumped. It's exactly the reverse what I said.
>If it's updatable then default for base should never be called.
>Cetin

Well I don't know why it didn't originally work but setting it updatable and removing the default value from the view enabled me to get it to work, and at the end of the day that's the main thing :)