Hi Mary-Ann,

As Ed points out, the key value for the KeyField is not unique. You see, for a view to update or delete correctly, one field has to be identified as the key field. This field has to be absolutely unique. To save you some time, this also means that you are going to want to use INSERT INTO to prepopulate this field with a unique value when inserting records.

As Ed also points out, if you can create a Primary or Candidate key on the field without an error, it's usable as the keyfield in a view.


>"The key defined by the KeyField Property for table dbc.table is not unique". Seems like a simple message, but I don't really understand what it means.
>
> Get this error when trying to delete or update from the view. The table has one key field that it's indexed on, the view is indexed on the same key field name. Have clicked on the key field on the update tab and those fields to update. Don't understand the problem.