>I have a basic design question about views.
>
>I've been placing multiple tables in one view where more than one of these tables is being updated by the view. I've been told that it's not a good idea to be updating more than one table in a view at a time. I had assumed that doing so whould acutally be better and more stable (as I only have to issue one tableudpate() command instead of 2 or 3) - but like I said now I'm hearing otherwise. Anyone have any thoughts on this?
>Thanks!
I think the views will get quite confusing when you try to update multiple tables.
If you have a parent-child relationship, I think you should have one view for the parent (or use the table directly), and another view for the child. In any one of the views, you can show related fields from other tables, but better don't update them.
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)