>>>>>>>I have an Oracle table being used as a remote view.Updates/edits show up in the view but when I close the view the changes are lost and don't show up in the Oracle table. Any suggestions?
>>>>>>
>>>>>>Sorry, it's silly but did you check SendUpdates box in View Designer?
>>>>> I went back and checked - the send SQL update box and the Update All command button on the update criteria tab in the view designer are both disabled.
>>>>
>>>>So, updates don't go back to table. To enable it you should select primary key and updatable field list and then check the box.
>>>Probably can't find the obvious - where do you select the updateable field list? I added a new remote view went all through the whole drill. Same thing.
>>
>>View Designer. Update Criteria Tab.
>>Field Name Pane Shows the fields that you have selected for output and, therefore, are available to update.
>>
>>· Key Field (marked with a key symbol) Specifies whether the field is a key field.
>>· Updatable (marked with a pencil symbol) Specifies whether the field is updatable.
>>· Field Name Displays the name of the output fields available to mark as key fields or updatable.
>I marked the key and updateable fields under the SQL WHERE and finally got a key and pencil.Then I followed your instructions. All fields have chek marks under the key or the pencil. Ran the procedure again. If I have the view opened in a browse and click on it after the procedure appends some records it shows the records. If I close the brow and reopen it the records are gone(probably since it refreshes form the Oracle table which did not get updated). If I run the procedure with the view being opened by the form the status bar shows the records being added but if I try to brow - No records. I tried the same procedure adding an Access table as a view - No problem. Also for what its worth all this time I am being harassed by a VB programer about how easy this is to do in VB - but then again it is April Fool's Day.

but i hope, this is not April 1 thread? :)
You should be really careful selecting key field (it must be really key primary field), else you can kill your data. Appending new records you must provide new key value.