There are several other threads on this topic where it's explained how to use Views to create a table in the Joomla DB that is basically a pointer to a table in another table.
But, that didn't work for me, so I came back to try and get some more info. I was able to create a view, but then when I went to set up a connection through the component, I would get an error saying I did not have a Primary Key defined.
Other than that, setting up the component to connect to the primary Joomla DB was a snap and worked exactly as advertised. If I can get a connection set up to my other DB, then it would definitely save me many more hours of work!
