>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
Check to make sure the Key field is updateable. By default, VFP makes this field non-updateable in the View Designer.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao