I don't think you qualify as a newbie any more, Ed. You've pulled together facts that have (as you say) caused excessive temperament in many programmers! A useful list for anyone beginning to use views.

Thanks
Barbara

>A View from (me) newbie.
>
>I would like to express my gratitude to Universal Thread for the education I am receiving from this forum. I’m articulating simple ideas that may help others new to VFP to avoid excessive temperament due to inconsistent behavior.
>
>VFP Views require each Child to be uniquely identified. A Child’s two-field concatenation is fine.
>
>If MANY Views are concurrently open referring to the same tables at any one instance you could get incorrect data after a REQUERY (and screen REFRESH) of only one of the Views. You are required by VFP to REQUERY each Updateable View using same-tables-in-use.
>
>Buffering of tables subordinate to Views can result in previous record results instead of current results after a REQUERY (and Screen REFRESH). Don’t Buffer tables accessed via Buffered Views.
>
>Many times the developer will have erroneous occurances - so strange or inconsistant that it is hard to formulate a question for the pros. Maybe this will help! Don’t take any of these ideas as the gospel, but I found them as the source of my troubles. Feed back from the pros is welcome. :~) Ed B