Hi Peter.

>> OK, this makes sense - sort of.... I may be a bit nieve but... If I use the View tools to create the view, how do
I control what records go INTO the view. They can change constantly when the user picks a different event
or bar from the drop down lists. The view needs to be updated at runtime. <<

PMFJI, but in this case you need a parameterized view. To set the view paramter in the view designer, under the filter tab, select the correct field from the drop down list on the left and type in the name of the paramter in the box on the right like this:

?vp_value

You need the '?' immediately in front of the variable name with no spaces between the '?' and the variable name.

The, in your form, when you want to change the information displayed in the grid, you use code like this:

vp_value = < some value >
REQUERY( 'MyView' )

One thing to watch out for: make sure that you have either reverted or commited any pending changes in the view before you requery it or you will get a VFP error.

HTH.

Marcia