Ooops....I meant in the DataEnvironment of the Report.

>Hi Dan --
>
>A local view is useful in a lot of situations, one being to manipulate child records where the parent can change. As to your report question, a view would best be used within the DataEnvironment of the form.
>
>>Hi all!
>>
>>Can anyone explain briefly what a local view is best used for and what is best used (query, table, view) in a form cmdbtn to send a SQL-Select statement to a report form when useing inner-joins between 3 tables?
>>
>>TIA
>>
>>Dan