I have several views that depend on the existance and prior population of other views. These are used almost exclusively in report data generation. The MM naming convention of using the prepended 'lv_' and 'rv_' so that either local or remote data can be used by the alias of 'v_' doesn't seem to work with creating a view based on a view since views need the names of the tables/views they are based on to generate (and not the alias.) Does any one have a way around this or am I missing something?
Thanks in Advance,
Gil Munk
"If a nation expects to be ignorant and free, it expects what never was and never will be." - Thomas Jefferson