Mark

Thanks for reply, here's a bit more info.

I can see the view created in my dbc but when I 'use' it to open it and then do a browse it displays all the original field names. Also if I refer to a field name, it returns 'variable not known'.

Sue