Vlad,

I found I could create a cursor and copy all record from my view into the cursor and relate the cursor to the other views to work around this. Have you run across any other way to handle this situation?

TIA

Rex

>Second view will never show you changes in first view until you update changes. This because VFP SQL SELECT command never take data from buffers, from disk only, skipping any changes/new records.
>
>>I have a series of views, dependent on one another to give the information needed. Only the first view is updatable. When I add a record to the first view and requery the second view, it does not requery.
>>
>>Is there anything with table and/or row buffering which would cause this? If so, what can be done to work around the problem?
>>
>>TIA
>>
>>Rex