>>>Two questions:
>>>1) Do you delete/add to view or to underlined table?
>>
>>I both delete and add to the underlying table, not the view. Then I issue "=requery('myview')" and grid Refresh commands to update the view.
>>
>>>2) Is inderlined table buffered?
>>In the main form where I delete records from the base table, the BufferOverrideMode is set to 1 for all associated tables/views.
>>
>>In my "Add a new contact" form, the BufferOverrideMode is set to 4. In the form's Init method, I add a blank record with a new key field value and default values in the other fields. Then when the user has selected a person and position from my dropdown boxes for the new record I issue a:
>> =tableupdate(1,.t.,"contacts") command
>>to update the table.
>>
>>I'm not incredibly sure how buffers work. Could this be my problem??
>>
>>Many thanks!
>>Mandy
>
>Firstly, the more natural way is to work (add/delete records to view). Also, BuffermodeOverride=1 just indicates that DE objects inherit buffering mode from Form.BufferMode setting, so check what you have there. Also, BufferModeOverride=4 (pessimistic table) is awfully awkward for real multi-user interface.
>Normal setting is following: table-buffered view and non-buffered underlined table.

Thanks as always Edward! I'll give it a whirl! :)

Mandy