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.

Regards
Doug Johnston