>Thanks for replying,
>
>my problem now is i use a view for display all unpaid order , and when the users changes data how to update the master table. in short how to update the master table when the user changes data in the view.
>
>txs

How did you create your view? In the View designer? If so, check Send SQL updates checkbox to write data back to the table...