My view of a view works fine I perform the update on the parent view, and include all the fields in both views it doesn't seem to matter which view changes the underlying data
thanks for all your help
Pete Kane

>>>>I have a view which has a maximum of 35 records, displayed in a grid on page1 of a 2 page pageframe, on page2 I want to display a subset of this grid, Is it better to create another view based on my current view or use set filter?
>>>>TIA
>>>>Pete Kane
>>>
>>>I have created non-updatable views of views with no problem. Well, I have had one problem that I can live with on a view of a table that is based on a field value in another open view [kind of a relation set up between 2 views without using indexes on the views]
>>>
>>>You could look at the code for the 2 views, and write [copy & paste] your own Create Sql View parameterized statement to create the 2nd view.
>>
>>The problem I have with the view of a table based on a field value in another open view is I can not edit the 2nd view again in the view designer because VFP can not find the 1st view in order to open it. Even though I have the DBC open, VFP is trying to find a table instead of a view. :(
>
>Thanks Mark,
>I'll let you know how I get on
>Pete Kane