>>Thanks Sergey, that was it. But, correcting that and running it again, I get the following error, "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'XPKtblCustomerType'. Cannot insert duplicate key in object 'tblCustomerType'."
>>
>>The SQL table has 2 fields marked as PK, own_Owner_Code and typ_Customer_Type. I assume that it is a concatenated key because own_Owner_Code is all the same value while typ_Customer_Type uses unique values.
>
>You can run following query to find duplicate keys that already exist in the view

SELECT cv.* FROM (cView) cv
>  JOIN (cTable) ct
>     ON ct.own_Owner_Code = cv.own_Owner_Code
>       AND ct.typ_Customer_Type = cv.typ_Customer_Type
>

Hi Sergey,

That doesn't work because cView is a remote view of a SQL Server table and cTable is a VFP table. But, I did check and discovered there are a number of records in the SQL Table that I wasn't aware had been entered, so that's probably the problem.

Thanks again,