I fixed the problem by opening the view in the Query Designer and removing the second table. Then put it back in. Now only the main table displayes in the tables property.
I tried to remove the second table using eView. I couldn't do it. The field that shows the Tables property is read-only or disabled. How do I do this using eView.
Also, I noticed this problem. I have some date fields that are defined as datetime in SQL Server. I can change the default type in the Query Designer to date. When I edit the view using eView the default type for these fields gets set back to datetime. I cannot change this in eView because the fields are disabled.
>
>Use DBSETPROP to remove the second table's name from the view's Tables property. Or remove it with eView.