Hello Doug
Thank you. At first check the two variables were correct. lcBaseTable is the view that I am using "v_contview" and lcPrimaryKey is correct as "contractno". So to my way of thinking if the default "newid()" was available in the view it should produce the unique next contractno.
You intimate that the view will obtain the unique next contractno from the underlaying table using its "newid()" procedure, is that correct?
I thought that the view was a separate entity and only passed information back to the table when the view closed! maybe I have the wrong idea of what a view is? Thank you for your input. Allan