Hi Wayne
thanks for your help in showing some insight .
this issue has now been resolved with the help of a few experts on this site .
and yes the views are now running perfect
all your comments re:
primary keys , Foreign keys
statistics
schema binding views
have all been taken into...