>Hi,
>
>I am under the assumption that a view can only update one table at a time. If I have a view with a simple join and want to update fields that exist in two tables that update would fail? Is this true?
>
>Thanks,
>
>Steve
I suspect that this is possible, but I consider it somewhat disorganized. I suggest to have a separate view for each table.
Of course, you can have additional fields (which I would treat as if they were R/O) from other, related tables, in a view.
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)