>All of the records are identical except for a unique PK field.
>The PK fields do not exist in the SQL Server table.
>
>Any ideas?

If the primary key columns do not exist on the server, what did you mark in the update criteria page in the view designer?

You have to tell VFP which columns are the the primary key on the server. When you issue a TABLEUPDATE, VFP creates an UPDATE statement and sends it to the server. If you have the WhereType set to PK and modified, the UPDATE will look something like this:

UDPATE table
SET changed_column = new_value
WHERE pk = OLDVAL(pk)
AND changed_column = OLDVAL(changed_column)

I'm not really sure what VFP would do if you caused it to create an UPDATE that modified multiple rows. Maybe that's the problem you having.

-Mike