Arnon,
>do you use a SELECT or a VIEW (CREATE SQL VIEW AS SELECT)
>REQUERY will only work on views
At first, I was attempting to use a VIEW and then assign it to a GRID so I could
update any tables associated with the VIEW. I figured out how to use a PARAMETER in the view, but not interactivly with a DROPDOWN. I could only get the data entry dialog box VFP brings up if there is a parameter there.
>as for making it parameterized use the syntax Gene offered
>you would probably want to specift NoDataOnLoad=.t. for the VIEW in the
>Dataenvironment as well
I'll try this in the VIEW, but still don't know how to tie the view/grid in with the DROP DOWN.
Thanks