June,

I get this often. And the way I always solve it, is by dropping the view and re-adding it. I know this doesn't answer 'why' it is happening, but as I have mentioned before to you, there are times when finding the answers why is not so important.

>Thanks for the suggestion.
>
>I did have some of table 2's fields interspersed with those of table 1 in the view, and corrected that, but I'm still getting the 1547.
>
>June
>
>>Hi,
>>Make sure your view's updatable fields is not seperated by any non-updateable field. For example, table1 is the source you want to update:
>>
>>**This should work fine
>>View : MyView
>>Selected Field List : MyTable1.Field1, MyTable1.Field2, MyTable2.Field1
>>
>>**This may cause error 1547
>>View : MyView
>>Selected Field List : MyTable1.Field1, MyTable2.Field1, MyTable1.Field2
>>
>>HTH