Hi Graeme,
<i><font color="#663300">When the view is created in the database you are only allowed one table join and even then the view insists on both tables being updateable.
Is the solution to hard code the view? and if so where does it go?
</font></i>
That is not a limitation of the database, but of the view designer. You can have and view you want by describing it in code use CREATE SQL VIEW AS. Running the command in the Command Window will install it in the database, you just won't be able to modify it with the view designer.
:-) Pamela
pamela AT eagle-crest .DO.T com
©2001 Pamela Thalacker |
