the reason i wanted to work exclusivly with views and not go back to the original source tables is that at some point in the future i may change this from using the VFP data engine to SQL server or MSDE. - Hence using views alone would minimise the amount of recoding etc...