>Thanks I got a copy of your article. Also I noticed that I didn't have a primary key name in the table as well in my view I made the parameter case sensitive. It works like a gem now. I knew it must be something I was doing wrong given all the talk of the advantages of using views particularly in Jim Booth book.

Glad to hear things are fixed.