>I want to create a view using 2 tables and need to be able to update the fields in the tables when a field in the view is changed. According to the help files with fox I can do it. Can anyone point me to a sample that would illustrate what i have to do?
On the view designer, go to "update criteria" tab and make sure that:
* Select what fields are updateables
* Select what field(s) is/are the primary key
* Check the "Send SQL Updates"
* Select WHERE clause "key fields only"
If you are using two tables in your view, make sure that changes are done to fields of only one table. Trying to update two tables from a single view will only get you into trouble.
Hector Correa