see if you can get the Data owner to Set up some Indexes on the Table that match your most freq. searches.

as you have stated above you are filling in a field on the view that is created from three fileds in the originating table so you are performing a full table search when you access the view it then creates this field entry then you are searching the the field for matches. I hope this helps explain part of your problem.

Thank you Stephen. I have stillthe same problem it just hangs.