>>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 ;-)

Just as a .02 worth for others tracking this thread, I don't use any SET RELATIONS either. I do the same as you here with parameterized views throughout.

Steve