Thanks Jose - I have been using eView for sometime. The View Designer has been fine as I haven't (so far) had to create any 'lots of table' views - it seems as if something has gone wrong in the DBC. or with the view designer - I need to get to the bottom of that I am afraid - any other ideas?