>Sorry Cetin - please ignore last post - I got it working - not sure how really!

You probably didn't have the database open first time. My advice would be to separate the views into another .dbc, i.e. take the code gendbc made, and split it so that the code for creating tables (and their .dbc) is in one .prg, and the code for creating the views (and their own .dbc) is in the other. The second .prg has to explicitly open the first .dbc, since all the views will be using tables from it.

The benefits of this approach are that anytime you change structure in any of the tables, you have ready code for re-creating all the views, regardless of you having encountered problems with them or not. At the same time, you don't touch the dbc where your tables are.

I'm actually going a step further, creating this views-only dbc on the user's temp directory, so everyone has their own. This eliminates some network issues, and speeds the things up a little bit.