I believe a primary key is required in order to make an updateable view. The key is used by the view to find the record in the master table to apply the update to.

PF

>Do views have to have the primary key in them? If you have six tables in a database that are related, and you choose to work with views, can you just pull out the fields from each that you need.