>>(.t.) ". At this point the local view source table (People) is updated with all fields from the local view except for the key field (people_id). The key field (people_id) is correct in the local view but blank in the source table.
>>
>>This of course causes an update conflict when the second new reord is added, because both have blank keys.
>>
>>I made the key field updatable in the local view. This does not help. Local view has "Send SQL updates" checked, SQL where clause includes "SQL Key fields only" and Update using "SQL Update".
>>
>>I feel this is just a small thing I have overlooked, but I cannot pin down what it is.
>
>Is this a multi-table view? You might want to generate and look at the view code to see if anything unusual is happening.
>
>Dan
No this is the simplest of views :
SELECT *;
FROM people;
WHERE People.address_id = ?address.address_id
Best Regards
Don Simpson