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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.