>Thanks for the reply, Erik. I'm surprised at how half the SQL side (SELECT) is prominently covered and the other (UPDATE) is shrouded in mystery.
>
Part of this is because the UPDATE statement has to be generated at runtime. IOW, it will be different for every TABLEUPDATE(), because different fields will be updated, depending on what fields have changed. The syntax should not matter to you, where the SELECT syntax is what partially determines the structure of your view.
>Thanks again for your help. Given my relative newness to VFP, I'm sure we'll be in contact more often than you'd normally like.
No problem.
Erik Moore
Clientelligence