Greetings David

was trying to avoid changing the code, but its not the end of the world.

So how would a temp.dbc work then? particularly if I want the view to be updateable...

>
>You can create them on the fly by using a CREATE SQL VIEW command. You probably want to use a TEMP.DBC to avoid the DBC bloat that is involved when a view is changed.