Thanks for the info, definitely helps...

I was also wondering if I was using the view Gui interface where I can pick tables or other views if I can point it to another database so the choices that come up are from that database. So lets say I am writing views on "reporting" database but I am getting my data from "data" databse. Whne I start my view and choose the gui the list of tables comes from "Data" but I am writing it in" reporting" databse Its not a big deal just wondering if I could set it to look at the other databse