>I have developed a order entry screen using grids. There are four grids one on each tab which are used to divide the products (ie four product groups). So what I have done is created a view with all products and for each tab depending on the product group generated a sub query to get the row source of the grid for the current tab. This works fine however if I globally want to add a discount I just update the root view and regenerate the sub views. Which is where I have discovered my problem. It updates all records except the last line of the current product group which is being displayed. Has anyone had such a problem??

I don't fully follow what you are doing, but if you have a SQL View of a View, you have to Requery() the parent view [and maybe do a TableUpdate() on it first] to update it. Then you can TableUpdate(), if necessary, then Requery() the child views. The actual order would be TableUpdate() all child views, TableUpdate() parent view(s), Requery() parent view(s), Requery() child views.