>If you use the Views only, wont this mean setting up an awful lot of views, presumably in the view designer in the datatbase ,and wont this create an overhead .... Is there any easy way of creating a view temporarily ?
The View Designer is really just a front end for the CREATE SQL VIEW command, which can be used to create a view on the fly.
That said, you need to be careful in a production environment - you may have difficulty deleting the view in a multi user environment, and if you do succeed in deleting it, if it happens often your DBC will begin to suffer from "bloat" due to the deleted records.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
