Hi Arnon,

Thanks for your help, I have a master views dbc in another directory and every time the app starts it takes a fresh copy from this. I had set the local views file OK but forgot to set the master one.

Once again thanks.

Regards
Doug Johnston


>>I have a dbc defined containing all my tables, one of which is contacts.dbf. It contains a number of index tags one of which is idnum, C, 10.
>>
>>I also have a dbc containing views of all the files in the original dbc and one of the views is vContacts.
>>
>>I have a form which has a number of views in the data environment and one being vContacts which is filtered on lcBegNum (beginning IDNUM) and lcEndNum (ending IDNUM).
>>
>>Initially the form starts with lcBegNum and lcEndNum = '0000000001'. All works fine.
>>
>>If I add a new record, the view is updated correctly displaying all the field data as it should including the newly created IDNUM, however, when I TABLEUPDATE(.T.) the original contacts.dbf has every field updated except for IDNUM which remains blank.
>>
>>Can someone please shed some lite on this problem.
>
>Hello Doug
>check your settings (DBGETPROP) for this field and correct whatever is wrong
>specifically make sure Updateable is set to .T. and that UpdateName is mapped to the correct field (contacts.idnum)
>
>Arnon