Hi Steve,
To share a connection, open the view, Select Advanced Option from menu and click on Share Connection.
>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