>I have been reading alot about parametized views during the past month here in the UT.
>I must confess, I am totally confused now!
>Can someone please explain more clearly what one is and how one might use it ( especially when using a grid).
>
>TIA
>Dan
Hi Dan.

You can set up a parameterized view either in code or in the View Designer if it is a stright parent - child - grandchild relationship. The VD doesn't handle relationships between unrelated siblings properly. To parameterize it, in the where clause specify where field name = ?. Then you can just put it in the data environment like any other table. Just be sure to set No Data On Load to true. Then, whenever you want to requery the view, just set to the desired value and REQUERY("VIEW").

Marcia