>Well part of the problem is that you have no control with a RV - which is why I don't use them. With RV - I BELIEVE - that if you insert into the view and both tables are set to be updated - that you will just create a null-filed record in the second table.
>
You are correct regarding the behavior of views here. But that's hardly a valid reason not to use them for other purposes. As stated before, this scenario is relatively rare, unless you and I have _vastly_ different data modeling techniques.
Erik Moore
Clientelligence