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