Hi Don---

Use a parameterized view for the grid, change the parameter and then REFRESH('viewname').

So, for example, if you had lineitems for an order in a grid, the view would be created as:

CREATE SQL VIEW vueLineItems AS ;
   SELECT * from lineitem WHERE order_no = ?order.order_no

Your "Next Order" button might contain code like this:

SELECT order
SKIP           && Changes to next order
=REFRESH('vueLineItems')
THISFORM.Refresh

>I have a bound grid but I would like to filter what is being viewed. I could use a query of view, but I need to be able to change the WHERE clause then refresh the control. What is the best way to accomplish this?