>Dear Nick and Barbara,
> I am try to using a view now. But i faced some problems.
> After i update the view, how to save it back to the original table ?
> And if the view records that have been deleted, how to make the original table record also to be deleted ?
> Is it i have to overwrite the original table by the updated view ? and how to overwirte a table by another table ?
> Thanks.
>
>regards,
>kengwen

Hi Kengwen,

You need to make your view updatable. Go to Update Criteria tab in the View Designer. You should put the checkmark beside your primary key in the field list there (under the key icon), and check all fields in the view which you want to update (under the pencil icon). Then Send Updates checkbox becomes enabled and you should check this one too. Save the view again.

When you need to send your updates to the table you issue TABLEUPDATE() function (check Help for determine which parameters you need for your case.)
Note that if the view is in Row buffering mode, then it will be updated automatically as soon as you move the record pointer in the view.