>Hi
>
>I got a view formed by two tables and the user is allowed to update all the fields of it.
>What is the most elegant and pragmatic way to delete records from this view but only one of the source tables gets it records deleted ( this is something like the details of an invoice)?
>
>Thanks in advance
I think you should only make the fields from the invoice-detail table updatable. Thus, the parent table should be untouched. You would include the parent table, to show additional fields - but you don't edit or delete them directly through the view. Look at the view update criteria (criterios de actualizacíón).
Saludos, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)