>Yes to all of that. If you don't have a book like 'Hackers Guide to VFP' then I suggest using the VFP Wizard to create the views you need.

I found that it works if I do not use my own alias, e.g. select table1.field1, table2.field1

It will create field1_a, field1_b and I can update these fields. But it doesn't look like a "kosher" approach. Can I use my own aliases?

Thanks.