>Using Local view for your tables.
I would suggest you to use Remote View in order to make your app scalable. You can optionally use VFP Database as Remote view.
>When I change my local base table to use local view, i append a record in local view, but the base table only update the key field.
Just make it sure that in your view definition, all necessary fields were marked as updateable.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."