>Hello all
>
>I'm just exploring my options to use the View in all my forms,is it a good practise to use views in forms,does it improve performance,what is the advantage of having views over tables in Dataenvironment of a form and good examples to learn more about updatable views in forms
>
>
>Thank you.

It depends on what you want to do with the data in those forms. The standard "display a record (possibly with child grids), edit/print the record, then save or discard the changes" process matches up very well with using views instead of the base tables.

You should also explore the possibility of using Remote Views instead of Local Views. If your system is designed with Remote Views, changing the back-end becomes infinitely easier. You could port your application to SQL Server, Oracle, or any other database with very few changes.

- Keith