I have a view for a table. The table has 1 primary key called CP_REF.

When I try to insert a record on the view using unique key references I keep getting the error "Uniqueness of CP_REF has been violated".

It only errors on the view, not the table.

What could this be?
Thanks
Kev