It's normally not considered good practice to have more than one file updated by a single view, but it is possible to do it. If you mark multiple keys, one for each table you need to update, it should work. Note, I said SHOULD work--no guarantees.

Another option would be to have two views, each for updating a single table, and set a relation between them so you can see data from both tables in the grid.

>Hi
>I got a table in which I add different types of products. All the products have several fields in common and some which are not. The fields which are not compatible between the products are stored in different tables. For each type of product there is a special form for adding, deleting and updating records.
>My problem is as follows: in every form I use a view to show the records in a
>grid ( I got to Do it this way as I got to select several records) this view is conformed by the two tables in which the data is scattered. So, my problem would be how I can add records to both tables through this view, whether when I insert a new record or decide to save The changes. Another problem that I got is that both tables got to be related by the field 'Key' which is added by user.
>What is the best way to address this type of problem?
>
>Thanks very much in advance