>Well I've only been doing this for 1 to 1 relationships, wouldnt want parent/child tables in the same view,... but if I have one view that holds 3 tables with 1 to 1 relationships for example....that to me seems like it would be ok to update the 3 tables from within the one view..???? I mean I know it works but I'm hearing from someone else that it's a 'bad idea and not stable'...but to me it seems like a good idea and more stable...hahaha

With one-to-one relationships, I would normally combine the information into a single table.

Anyway, in the case of the views, it is the one-to-many relationships that concern me. Note that I think a view on more than one table can be done, and perhaps you can even do so profitably. But personally, I feel a little incomfortable with the idea. It is nothing I can put my finger on right now, and I may be wrong...