>Hi Joss,
>
>>In my experience, trying to update multiple tables from a single view doesn't work (if you think about it, it doesn't make a whole lot of sense).
>
>You can send updates to multiple tables from a single view. You need to speficy the key field for each table though. An example would be an Incoice Header Table which is linked to the Customer table and the view would bring data from Invoice Header as well as customer.

As a rule of thumb, I try to stay away from updating more than one table in a view - it usually saves headaches in the long run
but as you said, it can be done

Arnon