>Jim,
>
>Go to the data environemtn and remove the table, add in the view and set the view's Alias property to be the same as the table's was. Then you don't have to change anything elsewhere.
Cool idea! Thanks!
Now, I need that table to house the data. Can I do this?
1. Rename the table to something else.
2. Then reference that table in the new Local View I create.
I just need to think about all this and see if I need to make any changes. The client has 50,000 records in their main PartMast table and it's getting VERY slow across the network. So, I decided to try the Local View thing which I probably should have done in the first place.
Thanks again,