You can have any number of views use a single connection. This is desireable because you may want the views to share a single connection to the server at run-time. The only way to do that is if they use the same connection.

You should be able to add a new view using the same connection like this:

1. Open the database designer (modify data mydata).
2. Click the toolbar button for new remote view.
3. Choose your existing connection from the list of connections in the dbc.
4. You should see a list of all the tables available via the connection you chose. Add one or more to the view.

>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