>Ken,
>
>Ok, I gotta you... Well the only thing I can think of is VFP views by default will not set the primary key field as updatable. Are you sure the key is checked as updatable in the view designer? I know you said it use to work but that is the only thing I can think of. You could check by opening the view in the IDE and type the following:
>
>? CURSORGETPROP("KeyFieldList")
>? CURSORGETPROP("UpdatableFieldList")
>? CURSORGETPROP("UpdateNameList")
>
>Make sure the field is in each of these lists.
>

Checked each one and yes, the field is there.

Seeing as I am completely stumped I put in a hack: I now set the default value of the table to the value of the field in the view. It means that I can not directly add records to the table if the view does not exist (and would insert a wrong value if it did) but since I only update the table from the view I should be ok (he says whil waiting for that call from the customer...)

Thanks for your idea,

ken