Since the view is a join between 2 tables (one being a lookup), I did have all the "non-lookup" fields as updateable.
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?
>>Make sure all the fields are marked updatable in the view's Update Criteria
>>tab.
>
>And "all the fields" does include the Primary Key, in case you're wondering...
It's "my" world. You're just living in it.