>I was thinking of creating a view based on the whole table, the view would have some calculated fields in it, then I would create small views based off the first view to directly populate a grid.
>
>I am not sure that the second view would update the original table. I may be better off just creating lots of small views for each grid required.

You may have to provide more info on this, it's a bit vague to me at the moment.

>I have another question, we have just ordered VFP7 (we are currently using VFP6) and was wondering what advantaged a view has over a updateable SQL statement?

Unfortunately I can't answer that, we are still using VFP6.

Kev