>Hi,
>
>Is there an easy way to update base tables for local views? Maybe I'm doing something wrong, but I've tried the TABLEUPDATE command, in conjunction with table buffering, etc., etc., and still can't get my base tables to update the way I'd like. It seems like the DBSETPROP command only works on remote views.
>
>I'd like to be able to enter data into a view, enter a simple command, and have my base tables reflect the changes.
>
>I've looked in the FAQ section, read several foxpro books about the matter, and waded through the help section of VFP, but haven't had much luck.
>
>Thanks for your help.
>-Jeremiah

When you design the view, make sure you check the box that says "Send SQL Updates" and that you have a primary key defined.