Please let me know if this would be a good idea in reference to tables and views. I have a table with about 100,000 records and potentially more containing information about subscribers. These subscriber subscribe thru one of three cities. I need to create a lookup screen that has three option button one for each city. When the user click the city button the lookup grid refreshes. I tried both using a view and a filter and found that you are correct in the fact that in the case views are slower. After the user locate the correct subscriber I need to pull in from multiple table information regarding that subscriber. So in this case the result set would be small. Would this be a good use for a view. Please let me know what your ideas are about this.