>>Can someone explain to me the "SQL WHERE clause includes" section of the View Designer's Update Criteria tab/page.

>In regard to SQL-Where question, you could check "Controlling How Update Conflicts are Detected" article from on-line Help. Basically, it's about how VFP will control (what fields) Tableupdate() conflicts.
>In regard to nested views. IMHO, that's not the to provide robust functionality. View Designer is tricky enough, but adding nested levels can make it too tricky. If you created nested views trying to work around View Designer limitations for complicated table joints, then it's better to proceed with programmatic CREATE SQL VIEW ...

I think you're right. I found some decent explanation of programmatically creating SQL views in the VFP Developer's Guide, so I'll read that section again and give it a whirl, as well as read the article on-line you mentioned.

Many thanks!

Mandy