>Hi.
>I have a remote view which is built from two joined by the view SQL Server tables. One table is main for the view and all its fields are marked updatable. Another table is supplementary, only two fields are used in the view and they are NOT updatable. Nevetheless, when i try to delete a record i get "No key columns specified for the updatable table ..." error. When i remove the second table from the view everything is fine.
>I've tryed comple rebuilding of the view. Database cleanup. Nothing helped.
>What makes it more perplexing is that in the same database there is an almost identical (with the same supplementary table) view which works just fine.
>VFP 7.0, SP1.
>
>Thanks.
>Kamil

Hi Kamil,

Probably, you have the second (supplementary) table mentioned in Tables property. Try to remove it from the Tables list.

Thanks,
Aleksey.