>First, I created a view for one single table and a connection to it. That seemed to work fine. I was able to read the data in the table from the view and select the records I wanted.
>
>Then, I wanted to make another view for a second single table. But I wasn't sure if I needed to make another second connection and connection name or if I could use the same connection for a second table and second view.
>
>Because the two tables are not related in any way. One table contains data such as parts, description, price. The second table contains data like employee information. Totally unrelated.
>
>I have several tables that need views and all tables are unrelated and need their own view. But I am not sure if they all need their own separate connection/name as well.
>
>I was thinking they might because I could not get it to let me add a second view to the original connection/name.
>
>HTH
Steve,
I have no conceptual propblem using a shared connection for totally unrelated tables if they are located in the same directory.
By the way, if you're using the VFP ODBC driver, be sure to use the 6.0 version. It has better performance and finally supports parameters for remote views.
Jose