>Since I'm wondering :), the actual updateable table has a PK that has it's
>default value in the field validation as NewID() to "generate" the value so how
>is this affected? If I append new recs to a "table", the PK is automatically
>generated and I don't have to supply a value. Is this not the case if I append
>recs to a view based on this table? Do I have to somehow generate a value for
>it?

<*rapidly running through recent studying for 70-26*> Argh, you had to ask. :-) I think I know how it _should_ work, but I think I also know how it _actually_ works. :-) If you have a view based on a local table, and the local table has a Default Value for the primary key, you need to make the Default Value for the view's primary key field the same as the table's primary key, and make it updatable. Otherwise, it tries to store Null (Blank?) there, and that violates the PK.

I'm not sure how it works against a server back end: I haven't had enough experience doing that to comfortably answer. Anyone else?