>Hi All,
>
>I cannot find anywhere a discussion on the relative merits of :
>
>- Using the Data Environment to open all required files
>- Coding the Opening of files
>- Using Table Views.
>
>Any ideas, or any article one can refer me to ?
>


I generally like to use private datasessions, so using the DE is the logical choice. I like the flexibility of multiple sessions of a form without going crazy trying to handle open tables through code. I do, however, use code to open tables or views for quick lookups or validation and them close them again...really depends on frequency of usage.

I use updateable, parameterized views for virtually ALL parent-child or table subset situations. I think I've forgotten the syntax of SET RELATION ;-)