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