>View MyView has a MyId field for which I have set the Default value as the function MakeNewId.
>
>This function does nothing more complex than look at a record in a table, increment the value of MyId and return the incremented value.
>
>The function is placed in the Stored Procedures of the DB and does what it's supposed to do.
>
>When I add a record to the view the expected values show up in the view.
>
>If I the issue a Tableupdate() the first record is inserted into the base-table with no values, and as a result I get a primary key violation on the second record.
>
>I can think of a few workarounds myself, so the question really is, is it possible to get the above scenario with SP functions and default values to work?
>
>TIA

Peter,
What fields are set in the Update Criteria tab of teh View Designer? If not using the View Designer, what fields are configured in the UpdatableFieldList property of the view?