>We use a stored produre to generate a unique number for Id-fields. The 'default value' of those fields calls the procedure. This usely works fine.
>
>Now we work with a view which update a certain table. When we perform an 'Insert' on the view a record is inserted in the table also. The table-record has a unique Id genated by the stored procedure but the record in the view is not updated and the Id is 0. I can not perform a 'Requery' because we are in the middle of a transaction.
>
>Does anybody know a good solution for this problem.
>Marco
I had a problem in the past, that I think that is happening to you. When you have a Default Value to a field in a table and you create a View based on this table you must have a Default Value to the field in the View also. Check if you have a Default Value in the View.
Regards,