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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
