Peter,

That's your problem. To create an updatable view your table must have a primary key. This is because VFP uses the SQL UPDATE command which needs some criteria to determine which record(s) to update. It is fairly standard when using SQL databases to require a primary key for every table.

>John,
>all the settings are set as you specify, but the field marked as the key is not unique as it's a child table
>Pete Kane